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

Reveal Solution 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

Reveal Solution 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

Reveal Solution Next Question