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

QUESTION: 36

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

The command forces the content of pg_hba.conf to be re-read into PostgreSQL server
process.
The command temporarily stops the PostgreSQL server process and restart it.
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.
The command forces the content of the database cluster to be re-read into PostgreSQL
server process.
The command causes a recovery to be performed from a standard backup file in the
PostgreSQL server process.

Answer(s): A,C

QUESTION: 37

I would like to set the default character encoding for the client to Unicode.
Select the most appropriate configuration parameter in postgresql.conf from those below.

backend_encoding = UNICODE
frontend_encoding = UNICODE
client_encoding = UNICODE
default_encoding = UTF8
encoding = UTF8

Answer(s): C

Show Answer Next Question

QUESTION: 38

Select two correct statements about the command shown below. Note: $ is the command prompt.
$ dropdb -U foo foodb

If foo doesn't have the OS superuser privilege, an error will occur.
If any table definition remains in database foodb, an error will occur.
This command removes database foodb.
This command removes all of the objects inside the database foodb.
The same process can be performed using the SQL command "DROP DATABASE".

Answer(s): C,E

Show Answer Next Question

QUESTION: 39

I would like to copy a database cluster directory for backup. Select two incorrect statements from below.

The directory must be copied after stopping the database server.
When using the Tablespace function, it is necessary to back up the directory that stores the
tablespace as well.
A database cluster that has been restored can be used on a separate machine with the same structure.
A database cluster that has been restored can be used on a newer version of PostgreSQL.
A database cluster that has been restored can be used on an older version of PostgreSQL.

Answer(s): D,E

Show Answer Next Question