support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Postgresql
  4. PGCES-02

Free PGCES-02 Exam Braindumps
PGCES-02 PostgreSQL CE 8 Silver Questions 31–35 (page: 8)

Updated On: 9-Feb-2026
Page 8 of 30
PDF with 142 Questions

Select one incorrect statement regarding psql.

  1. psql is an interactive SQL interpreter that enables a user to enter queries.
  2. For system security, only the PostgreSQL administrator account is allowed to use psql.
  3. "psql -l" displays a database list.
  4. "psql -U jan" will connect to the database called jan.
  5. Commands that begin with a backslash are processed internally in psql.

Answer(s): B



I would like to insert the contents of the text file users.dat into the table t1 using psql. Contents of text file users.dat:
Definition of table t1:
CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input from those below.

  1. \copy t1 FROM users.dat WITH DELIMITER ':'
  2. \copy t1 TO users.dat WITH DELIMITER ':'
  3. INSERT INTO t1 FROM file('users.dat');
  4. INSERT INTO t1 SELECT uname, pass, id FROM file('users.dat');
  5. \insert t1 FROM users.dat WITH DELIMITER ':';

Answer(s): A



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



  PDF
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:

AI Tutor AI Tutor 👋 I’m here to help!