PostgreSQL PGCES-02 Practice Questions| TestInsights

Question 1

Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.

A'PREPARE'/'EXECUTE' is mainly used to optimize performance.

B'PREPARE' creates a plan for the prepared statement.

C'PREPARE' can only specify 'SELECT' as a prepared statement.

D'EXECUTE' executes the plan defined by 'PREPARE'.

E'DEALLOCATE' deallocates prepared statements.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A'PREPARE'/'EXECUTE' is mainly used to optimize performance.

B'PREPARE' creates a plan for the prepared statement.

C'PREPARE' can only specify 'SELECT' as a prepared statement.

D'EXECUTE' executes the plan defined by 'PREPARE'.

E'DEALLOCATE' deallocates prepared statements.

0 / 1500

Question 2

Select one statement which will cause a syntax error.

ASELECT (SELECT item FROM sale WHERE id = 1);

BSELECT * FROM (SELECT * FROM customer);

CSELECT * FROM item WHERE cid IN
(SELECT cid FROM customer);

DSELECT * FROM sale WHERE name IN
(SELECT name FROM names);

ESELECT * FROM sale WHERE cid = ANY
(SELECT cid FROM customer);

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT (SELECT item FROM sale WHERE id = 1);

BSELECT * FROM (SELECT * FROM customer);

CSELECT * FROM item WHERE cid IN
(SELECT cid FROM customer);

DSELECT * FROM sale WHERE name IN
(SELECT name FROM names);

ESELECT * FROM sale WHERE cid = ANY
(SELECT cid FROM customer);

0 / 1500

Question 3

Select one SQL statement that will cause an error.

ASELECT version;

BSELECT current_user;

CSELECT current_date;

DSELECT current_timestamp;

ESELECT current_database();

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT version;

BSELECT current_user;

CSELECT current_date;

DSELECT current_timestamp;

ESELECT current_database();

0 / 1500

Question 4

Select two statements that the command below DOES NOT do.

Note: $ is the command prompt. $ pg_dump -b -F c b > d

ABacks up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

BBacks up the 'b' database to the 'd' file.

CBacks up large objects.

DBacks up the 'c' database to the 'd' file as the 'c' user.

ECreates a backup, which is restorable with the pg_restore command.

Correct : A, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ABacks up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

BBacks up the 'b' database to the 'd' file.

CBacks up large objects.

DBacks up the 'c' database to the 'd' file as the 'c' user.

ECreates a backup, which is restorable with the pg_restore command.

0 / 1500

Question 5

Select a correct SQL command to change existing user "george"'s password to "foobar".

AALTER USER george WITH PASSWORD 'foobar';

BALTER USER george CHANGE PASSWORD 'foobar';

CALTER USER george SET PASSWORD 'foobar';

DSET USER george PASSWORD TO 'foobar';

ESET USER george ALTER PASSWORD 'foobar';

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AALTER USER george WITH PASSWORD 'foobar';

BALTER USER george CHANGE PASSWORD 'foobar';

CALTER USER george SET PASSWORD 'foobar';

DSET USER george PASSWORD TO 'foobar';

ESET USER george ALTER PASSWORD 'foobar';

0 / 1500

Curious about Actual PostgreSQL Certified Engineer (PGCES-02) Exam Questions?

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: