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

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

The following are statements related to the postmaster. Select one statement that is incorrect.

  1. postmaster is a server process that receives connections from clients.
  2. The "pg_ctl start" command boots up postmaster.
  3. It is not possible to boot up the postmaster process by directly executing the postmaster
    command.
  4. One postmaster process controls one database cluster.
  5. The "pg_ctl stop" command stops postmaster.

Answer(s): C



What does the following command do? Choose the most appropriate statement from the selection below.
Note: $ is the command prompt.
$ pg_dump postgres > pgsql

  1. Writes a backup of the database postgres to the file pgsql.
  2. Writes a backup of the entire database cluster using user postgres to the file pgsql.
  3. Backs up the database postgres and writes an error message to the file pgsql.
  4. Writes a backup of the entire database cluster to the file postgres and writes an error
    message to the file pgsql.
  5. Outputs all of the content of the database postgres to the screen using the user pgsql.

Answer(s): A



I would like to check the privileges on the "items" table in psql. Select the most appropriate command.

  1. \a items
  2. \d items
  3. \t items
  4. \p items
  5. \z items

Answer(s): E



Select an appropriate command to check the PostgreSQL version in psql.

  1. \server_version
  2. SELECT version;
  3. SELECT version();
  4. SHOW version;
  5. SHOW server;

Answer(s): C



Select one incorrect statement about the command shown below. Note: $ is the command prompt.
$ dropuser -U admin foo

  1. If there is a database owned by foo, an error will occur.
  2. If admin is not the owner of foo, an error will occur.
  3. If admin doesn't have the superuser privilege, an error will occur.
  4. The user admin is removing the user foo.
  5. The same process can be performed using the SQL command "DROP USER".

Answer(s): B



Viewing page 4 of 30
Viewing questions 16 - 20 out of 142 questions



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

Join the PGCES-02 Discussion