Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Postgresql
  5. PGCES-02

Postgresql PGCES-02 Exam
PGCES-02 PostgreSQL CE 8 Silver (Page 8 )

Updated On: 12-Jan-2026
Page 6 of 30
PDF with 142 Questions

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

  1. First normal form
  2. Second normal form
  3. Third normal form
  4. Boyce/Codd normal form
  5. Fourth normal form

Answer(s): A



Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.

  1. SAVEPOINT function was added.
  2. Point-In-Time Recovery function was added.
  3. The shared buffer control algorithm was improved.
  4. Two-phase commit function was added.
  5. CSV mode was added to the copy command.

Answer(s): D



Select one false statement about the benefits of using database management systems from below.

  1. You can separate the data storage method from the application.
  2. You can separate the data search method from the application.
  3. You can separate the data display method from the application.
  4. You can reduce the programming workload of programming for managing data.
  5. You can share data more easily on systems consisting of multiple computers.

Answer(s): C



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

  1. This is a backup method integrating a physical backup and a transaction log (WAL).
  2. It is necessary to stop the database server to perform a backup for the first time.
  3. Updated data is continuously saved.
  4. A restore can be performed to any arbitrary point in time since the starting point of PITR.
  5. A backup can only be performed on a per-database basis.

Answer(s): B,E



SQL statements were executed in the following order. CREATE TABLE book (
id VARCHAR(21), title TEXT NOT NULL, price INT, UNIQUE (id), CHECK (price > 0)
);
INSERT INTO book VALUES ('4-12345-678-9', 'SQL book', 2300); --(1) INSERT INTO book (title, price) VALUES ('PostgreSQL', 3000); --(2) UPDATE book SET id = '4-12345-678-9' WHERE id IS NULL; --(3)
DELETE FROM book WHERE price < 0; --(4)
While executing, select the first location that generates an error.

  1. (1)
  2. (2)
  3. (3)
  4. (4)
  5. No error is generated.

Answer(s): C



Viewing page 8 of 30
Viewing questions 36 - 40 out of 142 questions



Post your Comments and Discuss Postgresql PGCES-02 exam prep with other Community members:

Join the PGCES-02 Discussion