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

Free PGCES-02 Exam Braindumps

Select one correct statement about the createlang command.

  1. It is a command for setting the locale for a database.
  2. It is a command for registering a procedural language into a database.
  3. It is a command for creating a user defined function.
  4. It is a command for adding message catalogs.
  5. It is a command that has been discarded for version 8 and later.

Answer(s): B



What does the following command do? Select two correct descriptions regarding this SQL statement.
SELECT * FROM information_schema.tables;

  1. Requests a list of defined tables in the currently connected database.
  2. Requests a list of defined tables in the "information_schema" database.
  3. Requests the contents of the "tables" table in the "information_schema" database.
  4. Requests the contents of the "tables" table in the "information_schema" schema.
  5. Requests a list of defined tables in the "information_schema" schema.

Answer(s): A,D



Select two correct statements that describe what occurs on the client side when the following command is executed.
pg_ctl -m smart stop

  1. Clients will not be able to make new connections.
  2. The running transaction for a connected client is rolled back and the connection is
    disconnected forcibly.
  3. Connections are terminated after the currently running transactions have finished.
  4. The processes of currently connected clients are processed normally.
  5. Connected clients receive a message saying that the server will soon be shutdown.

Answer(s): A,D



Select two correct statements about the command shown below. Note: $ is the command prompt. $ pg_ctl reload

  1. The command forces the content of pg_hba.conf to be re-read into PostgreSQL server
    process.
  2. The command temporarily stops the PostgreSQL server process and restart it.
  3. The command re-reads the postgresql.conf details into the PostgreSQL server process and
    changes the values of any configuration parameters that can be changed.
  4. The command forces the content of the database cluster to be re-read into PostgreSQL
    server process.
  5. The command causes a recovery to be performed from a standard backup file in the
    PostgreSQL server process.

Answer(s): A,C






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

Exam Discussions & Posts