PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02 Exam Questions [2026]

QUESTION NO: 1
Select two incorrect statements regarding 'DOMAIN'.

A. A domain is created by 'CREATE DOMAIN'. B. To define a domain, both input and output functions are required. C. When defining a domain, you can add a default value and constraints to the original data. D. A domain can be used as a column type when defining a table. E. Domain is a namespace existing between databases and objects such as tables.

Correct Answer: B,E

QUESTION NO: 2
I want to restore data from a text format backup file foo.dump. Select an appropriate command.

A. createdb foo < foo.dump B. pg_restore -d foo foo.dump C. pg_dump -R foo < foo.dump D. psql -f foo.dump foo E. pg_restore -f foo.dump foo

Correct Answer: D

QUESTION NO: 3
The "sample" table consists of the data below. The column "x" is of type INTEGER. How many
rows are returned by executing the following SQL statement?
SELECT 6 / x FROM sample
WHERE CASE WHEN x = 0 THEN FALSE ELSE TRUE END;

A. 2 rows B. 0 rows with no errors. C. 3 rows D. "ERROR division by zero" and no rows are returned. E. 1 row

Correct Answer: A

QUESTION NO: 4
What does the following command do? Choose the most appropriate statement from the selection
below.
Note: $ is the command prompt.
$ pg_dump postgres > pgsql

A. Writes a backup of the entire database cluster using user postgres to the file pgsql. B. Outputs all of the content of the database postgres to the screen using the user pgsql. C. Writes a backup of the database postgres to the file pgsql. D. Backs up the database postgres and writes an error message to the file pgsql. E. Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.

Correct Answer: C

QUESTION NO: 5
Which normal form has the constraint that there must be no tables with duplicate column values in the same row?

A. Fourth normal form B. Second normal form C. Boyce/Codd normal form D. Third normal form E. First normal form

Correct Answer: E

QUESTION NO: 6
A table is defined as below. Select the most suitable description about the foreign key constraint.
CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE record (id INTEGER REFERENCES master (id), count INTEGER);

A. If the "record" table contains a row with an "id", the corresponding "id" row in the "master" table cannot be deleted. B. If any row exists in the "record" table, no change can be made to the "master" table. C. The "record" table cannot have duplicate "id"s. D. These SQL statements are invalid; no constraints are created. E. If the "record" table contains a row with an "id", no change can be made at all to the corresponding "id" row in the "master" table.

Correct Answer: A

QUESTION NO: 7
SQL statements were executed in the following order: CREATE TABLE fmaster
(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ftrans
(id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE); INSERT INTO fmaster
VALUES (1, 'itemA');
INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
Select the two SQL statements that will generate an error when executed next.

A. INSERT INTOfmaster VALUES (1, 'itemB'); B. INSERT INTOftrans VALUES (1, 2, NULL); C. UPDATEfmaster SET name = NULL; D. DELETE FROMfmaster; E. DROP TABLEftrans;

Correct Answer: A,D

QUESTION NO: 8
Select one incorrect statement about the command shown below. Note: $ is the command prompt. $ dropuser -U admin foo

A. The user admin is removing the user foo. B. The same process can be performed using the SQL command "DROP USER". C. If admin is notthe owner of foo, an error will occur. D. If there is a databaseowned by foo, an error will occur. E. If admin doesn't havethe superuser privilege, an error will occur.

Correct Answer: C