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 41–45 (page: 10)

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

Choose the most suitable statement about user management of PostgreSQL.
Note: the version of PostgreSQL is 8.0.

  1. Usernames not registered in the operating system cannot be registered as PostgreSQL
    users.
  2. To create a new user for PostgreSQL, the "newuser" command is used.
  3. PostgreSQL cannot be in a state where multiple users exist at the same time.
  4. If you create a user that has permission to create other users, that user will become a
    superuser that is not subject to any access restriction checks.
  5. To delete an existing user for PostgreSQL, "deleteuser" command is used.

Answer(s): D



I would like to enable all users to SELECT the "item" table.
Select the most appropriate SQL statement from below.

  1. GRANT public SELECT ON item;
  2. GRANT SELECT ON item TO public;
  3. REVOKE 'r' ON item TO public;
  4. REVOKE READ ON item TO public;
  5. REVOKE public SELECT ON item;

Answer(s): B



Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL.
local all all trust
host all all 192.168.1.0/24 reject
host all all 192.168.0.0/16 trust
Select a host IP address which is authorized to connect to this database via the network. Note: INET domain socket communication is available.

  1. 127.0.0.1
  2. 192.168.1.1
  3. 192.168.0.1
  4. 192.168.1.0
  5. None can be connected.

Answer(s): C



Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.

  1. pg_ctl stop
  2. pg_ctl -m fast stop
  3. pg_ctl -m immediate stop
  4. pg_ctl -m wait stop
  5. pg_ctl -s stop

Answer(s): A



Select the most appropriate setting to output the log messages of the database to syslog.

  1. "syslog = true" in postgresql.conf.
  2. "log_destination = 0" in postgresql.conf.
  3. "log_destination = 1" in postgresql.conf.
  4. "log_destination = 2" in postgresql.conf.
  5. "log_destination = syslog" in postgresql.conf.

Answer(s): E



  PDF
Viewing page 10 of 30
Viewing questions 46 - 50 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!