Free PGCES-02 Exam braindumps download (PGCES-02 exam dumps Free)

QUESTION: 46

Select one option which cannot be specified using createdb.

Database locale
Character encoding
Host name
Database owner
Template database

Answer(s): A

Show Answer Next Question

QUESTION: 47

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

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

Answer(s): C

Show Answer Next Question

QUESTION: 48

Select two suitable statements regarding the pg_dump command.

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

Answer(s): C,E

Show Answer Next Question

QUESTION: 49

Based on the following request, select the most appropriate command for creating a database cluster.
?Character encoding of the template database needs to be EUC_JP ?Locale is not used