Practice PGCES-02 Exam Online

Question 1

The table 'custom' is defined below. The 'id' column and 'introducer' column are of

INTEGER type, and the 'email' column is of TEXT type.

id | email | introducer ----+-- ---------------+-----------2 |

[email protected] | 1 3 |

[email protected] | 2 4 |

[email protected] | 2

Three SQL statements were executed in the following order:

UPDATE custom SET email = '' FROM custom c WHERE

custom.introducer = c.id; UPDATE custom SET introducer = NULL

WHERE introducer NOT IN (SELECT id FROM custom); DELETE

FROM custom WHERE id = 2 OR introducer = 2; Select the number of rows in the 'custom' table after the execution.

A : 0 rows

B : 1 row

C : 2 rows

D : 3 rows

E : 4 rows

Answer: A

Question 2

Select two SQL statements which abort a transaction.

A : END

B : ROLLBACK

C : TRUNCATE

D : ABORT

E : DROP TRANSTACTION

Answer: B,D

Question 3

Select an appropriate command to check the PostgreSQL version in psql.

A : \server_version

B : SELECT version;

C : SELECT version();

D : SHOW version;

E : SHOW server;

Answer: C

Question 4

Select an incorrect statement regarding the following SQL statement. Note that 'user_view' is a view. CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;

A : It is defining a rule 'rule_1'.

B : It will replace 'rule_1' if it already exists.

C : Executing 'UPDATE user_view' will no longer output errors.

D : When executing 'UPDATE user_view', data is updated in the table that is the origin of the view.

E : 'DROP RULE rule_1 ON user_view' deletes the above definition.

Answer: D

Question 5

Select one incorrect statement from the below about a database cluster.

A : It is possible to have multiple databases within a database cluster.

B : A database cluster is created using initdb command.

C : Each host can have only one database cluster.

D : Special databases called template0 and template1 are created in a database cluster by default.

E : When a database cluster is created, a database superuser is registered using the username of the OS at the time of creation unless otherwise designated.

Answer: C

Name:	CE 8 Silver
Exam Code:	PGCES-02
Certification:	PostgreSQL Certified Engineer
Vendor:	PostgreSQL
Total Questions:	145
Last Updated:	Apr 25, 2024

PostgreSQL PGCES-02