Question No. 1

The table "t1" is defined below. The column "id"

for table "t1" is of INTEGER type.

id | name ----

+-----------1 |

mammoth 2 |

tortoise 3 |

coelacanth

The following SQL statements were executed. Select the correct statement about the execution result. BEGIN; DECLARE c SCROLL CURSOR FOR SELECT name FROM t1 ORDER BY id;

MOVE FORWARD 2 FROM c; FETCH FORWARD ALL FROM c; COMMIT;

AThe number of rows returned by the FETCH statement is 0.

BThe number of rows returned by the FETCH statement is 1.

CThe number of rows returned by the FETCH statement is 2.

DThe number of rows returned by the FETCH statement is 3.

EAn error occurs part way through.

Show Answer

Correct Answer: B

Question No. 2

Which normal form has the constraint that there must be no tables with duplicate column values in the same row?

AFirst normal form

BSecond normal form

CThird normal form

DBoyce/Codd normal form

EFourth normal form

Show Answer

Correct Answer: A

Question No. 3

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

AIt is possible to have multiple databases within a database cluster.

BA database cluster is created using initdb command.

CEach host can have only one database cluster.

DSpecial databases called template0 and template1 are created in a database cluster by default.

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

Show Answer

Correct Answer: C

Question No. 4

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

AThis is a backup method integrating a physical backup and a transaction log (WAL).

BIt is necessary to stop the database server to perform a backup for the first time.

CUpdated data is continuously saved.

DA restore can be performed to any arbitrary point in time since the starting point of PITR.

EA backup can only be performed on a per-database basis.

Show Answer

Correct Answer: B, E

Question No. 5

Based on the following request, select the most appropriate command for creating a database cluster. ?Character encoding of the template database needs to be EUC_JP ?Locale is not used

Ainitdb --locale=EUC_JP --no-encoding

Binitdb --default-encoding=EUC_JP

Cpg_ctl init --locale=EUC_JP

Dinitdb --encoding=EUC_JP --no-locale

Epg_ctl init --encoding=EUC_JP

Show Answer

Correct Answer: D

Free PostgreSQL PGCES-02 Exam Actual Questions

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