Free PostgreSQL PGCES-02 Exam Actual Questions

The questions for PGCES-02 were last updated On Nov 7, 2024

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;

Show Answer Hide Answer
Correct Answer: B

Question No. 2

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 with the following content on the client side. 1,Pgsql \,inc. 2,Postgres Co. \,Ltd 3,SQL Company.

Show Answer Hide Answer
Correct Answer: C

Question No. 3

Select the most suitable statement about PostgreSQL from below.

Show Answer Hide Answer
Correct Answer: E

Question No. 4

Select two correct statements that describe what occurs on the client side when the following command is executed. pg_ctl -m smart stop

Show Answer Hide Answer
Correct Answer: A, D

Question No. 5

Select the most suitable statement regarding PostgreSQL's pg_hba.conf configuration file.

Show Answer Hide Answer
Correct Answer: D