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

Free PGCES-02 Exam Braindumps (page: 13)

Page 12 of 36
PDF with 142 Questions

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



Select one option which cannot be specified using createdb.

  1. Database locale
  2. Character encoding
  3. Host name
  4. Database owner
  5. Template database

Answer(s): A



You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?

  1. This change will take effect as soon as postgresql.conf is saved.
  2. This change will take effect by executing "pg_ctl reload".
  3. This change will take effect by executing "pg_ctl restart".
  4. This change will take effect after rebooting the OS, because the new option is recorded as an OS parameter.
  5. This setting is invalid unless the change is made while postmaster is stopped.

Answer(s): C



Select two suitable statements regarding the pg_dump command.

  1. pg_dump is an SQL command.
  2. Only the user who executed initdb can execute pg_dump.
  3. pg_dump can create a backup while postmaster is running.
  4. pg_dump can create a backup while postmaster is stopped.
  5. pg_dump can create a backup of a specified table.

Answer(s): C,E






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

PGCES-02 Exam Discussions & Posts