Practice PGCES-02 Exam Online

Question 1

Select two SQL statements which abort a transaction.

A : END

B : ROLLBACK

C : TRUNCATE

D : ABORT

E : DROP TRANSTACTION

Answer: B,D

Question 2

Select two incorrect statements concerning PostgreSQL license.

A : It can be used freely.

B : It can be duplicated freely.

C : It can be freely redistributed.

D : Developers are responsible for its maintenance support.

E : Developers are only responsible for handling its crucial faults.

Answer: A,D

Question 3

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 4

The following table called 'company' is defined as follows:

id | name ----+--------

---------- 1 |

Pgsql,inc. 2 |

Postgres Co.,Ltd 3 |

SQL Company.

Select the most appropriate psql command for generating a text file company.txt on the client side with the following content: 1,'Pgsql,inc.' 2,'Postgres Co.,Ltd' 3,SQL Company.

A : \copy company TO 'company.txt' WITH ','

B : \copy company TO 'company.txt' WITH DELIMITER AS ','

C : \copy company TO 'company.txt' DELIMITER ','

D : \copy company TO 'company.txt'

E : \copy company TO company.txt CSV

Answer: A

Question 5

Which psql command do you need to execute to display the list of tables in the currently connected database?

A : SELECT * FROM pg_table_list;

B : SHOW tables;

C : \dT

D : \dt 'database_name'

Answer: A

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