PostgreSQL CE 8 Silver (PGCES-02) - Post SQL Actual Exam Questions
Last updated on May 01, 2026
The following question concerns the use of multibyte characters in PostgreSQL. Select two correct items about character encoding in PostgreSQL.
"./configure --enable-multibyte" must be designated at time of build.
When the database cluster is initialized, the or --multibyte option must be specified.
Character encoding can be set on a per database basis.
Only a single character encoding can be specified for each database cluster.
Different character encodings can be specified for server and clients.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
The table "t1" is defined by the following SQL statement: CREATE TABLE t1 (id integer, name varchar(20)); You want to increase the execution speed of the SQL statement below: SELECT id, name FROM t1 WHERE id < 123 AND upper(name) = 'MAMMOTH'; Select the most suitable SQL statement to create an index.
CREATE INDEX t1_idx ON t1 (id, upper(name));
CREATE INDEX t1_idx ON t1 USING HASH (id);
CREATE INDEX t1_idx ON t1 (name);
ALTER TABLE ADD INDEX ON t1 (id, upper(name));
ALTER TABLE ADD INDEX ON t1 (id, name);
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
I would like to check the privileges on the "items" table in psql. Select the most appropriate command.
\a items
\d items
\t items
\p items
\z items
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.
SAVEPOINT function was added.
Point-In-Time Recovery function was added.
The shared buffer control algorithm was improved.
Two-phase commit function was added.
CSV mode was added to the copy command.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
The following SQL defines an INSERT with respect to item_view. Select the keyword that is applicable in the underlined blank. CREATE _______ foo AS ON INSERT TO item_view DO INSTEAD INSERT INTO item_table VALUES (NEW.id, NEW.itemname);
RULE
VIEW
TRIGGER
FUNCTION
CONSTRAINT
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.