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 3 )

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

Based on the relationship of columns within a table, select the most suitable description that
shows that column A is dependent on column B.

  1. The value in column B is uniquely determined when a value in column A is selected.
  2. The value in column A is uniquely determined when a value in column B is selected.
  3. When the value in column A is changed, the corresponding value in column B also must be
    changed.
  4. When the value in column B is changed, the corresponding value of column A also must be
    changed.
  5. As long as column B exists, the amount of information will not decrease even if column A is
    deleted.

Answer(s): B



Select the most suitable statement about PostgreSQL from below.

  1. There are PostgreSQL GPL license versions and commercial license versions.
  2. You need to be pre-registered to use PostgreSQL.
  3. PostgreSQL can be used by everyone free of charge for any purpose, be it private,
    commercial, or academic.
  4. You can use PostgreSQL for free; however, the source code is not open to the public.
  5. PostgreSQL is shareware.

Answer(s): C



I want to restore data from a text format backup file foo.dump. Select an appropriate command.

  1. pg_dump -R foo < foo.dump
  2. pg_restore -d foo foo.dump
  3. pg_restore -f foo.dump foo
  4. psql -f foo.dump foo
  5. createdb foo < foo.dump

Answer(s): D



Select two incorrect statements related to the command below. Note: $ is the command prompt.
$ psql -U foo -c "COPY company TO stdout;" bar

  1. If the company table is not readable, an error occurs.
  2. The content of the company table is written into a file called 'stdout'.
  3. The content of the company table is output in TAB delimited format.
  4. An error occurs unless the user foo has administrator privileges.
  5. Connects to the database bar.

Answer(s): B,D



It is possible to backup a database cluster by copying the entire data directory. Select two
suitable descriptions regarding this backup method.

  1. The backup data will be a text file consisting of SQL statements.
  2. The database server must be stopped prior to the backup.
  3. The "pg_restore" command is used to restore the database.
  4. "psql" is used to restore the database.
  5. You can use standard tools like "tar" and "rsync" to backup files and directories.

Answer(s): B,E



Viewing page 3 of 30
Viewing questions 11 - 15 out of 142 questions



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

Join the PGCES-02 Discussion