Question No. 1

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction. Select one answer containing the correct keyword(s) to fill in the underlined blank below. DECLARE cursor1 __________ FOR SELECT * FROM customer;

ACURSOR

BSCROLL CURSOR WITH HOLD

CINSENSITIVE CURSOR

DNO SCROLL CURSOR WITH HOLD

ECURSOR WITHOUT HOLD

Show Answer

Correct Answer: B

Question No. 2

Select two correct statements about the command shown below.

Note: $ is the command prompt. $ dropdb -U foo foodb

AIf foo doesn't have the OS superuser privilege, an error will occur.

BIf any table definition remains in database foodb, an error will occur.

CThis command removes database foodb.

DThis command removes all of the objects inside the database foodb.

EThe same process can be performed using the SQL command 'DROP DATABASE'.

Show Answer

Correct Answer: C, E

Question No. 3

What does the following command do? Choose the most appropriate statement from the selection below.

Note: $ is the command prompt.

$ pg_dump postgres > pgsql

AWrites a backup of the database postgres to the file pgsql.

BWrites a backup of the entire database cluster using user postgres to the file pgsql.

CBacks up the database postgres and writes an error message to the file pgsql.

DWrites a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.

EOutputs all of the content of the database postgres to the screen using the user pgsql.

Show Answer

Correct Answer: A

Question No. 4

Select the most appropriate statement about the initdb command.

AIt can not be executed by an OS administrator-level user (root user).

BIt can only be executed by the user who installed PostgreSQL.

CUnless the environment variable PGDATA is set, it can not be executed.

DWhen 'auto' is designated as the value for the environment variable PGDATA, a directory is automatically set up.

EThe directory designated by the environment variable PGDATA must exist.

Show Answer

Correct Answer: A

Question No. 5

Select two commands used to check the syntax of the ALTER TABLE statement in psql.

A\h ALTER TABLE

B\h ALTER

C\ ALTER TABLE

D\ ALTER

EHELP ALTER TABLE;

Show Answer

Correct Answer: A, B

Free PostgreSQL PGCES-02 Exam Actual Questions

The questions for PGCES-02 were last updated On Jan 18, 2025