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

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

What does the following command do? Choose two incorrect statements from the selection below.
Note: $ is the command prompt.
$ pg_restore -U postgres -d database1 database1.dump

  1. This command restores the database database1 from the file database1.dump.
  2. This command connects to a database as the user 'postgres'.
  3. This command can not be executed unless the postmaster is running.
  4. This command can not restore large objects.
  5. This command must be executed under the condition where the database database1 does
    not exist.

Answer(s): D,E



Select the most suitable statement about the creation of a new database.

  1. Only a PostgreSQL superuser is authorized to create a new database.
  2. The target directory is specified by the environment variable PGDATA or the -D parameter
    when creating a database.
  3. Only one database can be used at the same time even if two or more databases are created.
  4. Only the OS superuser (root) can create databases.
  5. You can set the character encoding when creating a new database.

Answer(s): E



Select the most appropriate statement about the initdb command.

  1. It can not be executed by an OS administrator-level user (root user).
  2. It can only be executed by the user who installed PostgreSQL.
  3. Unless the environment variable PGDATA is set, it can not be executed.
  4. When "auto" is designated as the value for the environment variable PGDATA, a directory is
    automatically set up.
  5. The directory designated by the environment variable PGDATA must exist.

Answer(s): A



The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2".
Select a correct keyword to fill in the blank below.
SELECT * FROM t1 ______ SELECT * FROM t2;

  1. EXCEPT
  2. UNION
  3. NAND
  4. INTERSECT
  5. INTERSECT ALL

Answer(s): A



Select two suitable statements about the BSD license from below.

  1. If you make changes to the source code, feedback must be sent to the original developers.
  2. It is used by open source software.
  3. User registration is required.
  4. It is defined by Free Software Foundation, Inc. (FSF).
  5. Software under the BSD license can be incorporated with any programs provided that the
    copyright notice appears in all copies.

Answer(s): B,E



Viewing page 5 of 30
Viewing questions 21 - 25 out of 142 questions



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

Join the PGCES-02 Discussion