PostgreSQL-CE PostgreSQL-CE Certifications PGCES-02 Questions & Answers

• Question 101:

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

  A. Usernames not registered in the operating system cannot be registered as PostgreSQL users.

  B. To create a new user for PostgreSQL, the "newuser" command is used.

  C. PostgreSQL cannot be in a state where multiple users exist at the same time.

  D. 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.

  E. To delete an existing user for PostgreSQL, "deleteuser" command is used.

  Correct Answer: D

• Question 102:

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

  A. GRANT public SELECT ON item;

  B. GRANT SELECT ON item TO public;

  C. REVOKE 'r' ON item TO public;

  D. REVOKE READ ON item TO public;

  E. REVOKE public SELECT ON item;

  Correct Answer: B

• Question 103:

  Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust

  host 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.

  A. 127.0.0.1

  B. 192.168.1.1

  C. 192.168.0.1

  D. 192.168.1.0

  E. None can be connected.

  Correct Answer: C

• Question 104:

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

  A. pg_ctl stop

  B. pg_ctl -m fast stop

  C. pg_ctl -m immediate stop

  D. pg_ctl -m wait stop

  E. pg_ctl -s stop

  Correct Answer: A

• Question 105:

  Select two correct statements that describe what occurs on the client side when the following command is executed.

  pg_ctl -m smart stop

  A. Clients will not be able to make new connections.

  B. The running transaction for a connected client is rolled back and the connection is disconnected forcibly.

  C. Connections are terminated after the currently running transactions have finished.

  D. The processes of currently connected clients are processed normally.

  E. Connected clients receive a message saying that the server will soon be shutdown.

  Correct Answer: AD

• Question 106:

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

  A. The command forces the content of pg_hba.conf to be re-read into PostgreSQL server process.

  B. The command temporarily stops the PostgreSQL server process and restart it.

  C. 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.

  D. The command forces the content of the database cluster to be re-read into PostgreSQL server process.

  E. The command causes a recovery to be performed from a standard backup file in the PostgreSQL server process.

  Correct Answer: AC

• Question 107:

  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.

  A. backend_encoding = UNICODE

  B. frontend_encoding = UNICODE

  C. client_encoding = UNICODE

  D. default_encoding = UTF8

  E. encoding = UTF8

  Correct Answer: C

• Question 108:

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

  A. If foo doesn't have the OS superuser privilege, an error will occur.

  B. If any table definition remains in database foodb, an error will occur.

  C. This command removes database foodb.

  D. This command removes all of the objects inside the database foodb.

  E. The same process can be performed using the SQL command "DROP DATABASE".

  Correct Answer: CE

• Question 109:

  Select the most suitable statement about PostgreSQL from below.

  A. PostgreSQL is a card-type database management system.

  B. PostgreSQL is a hierarchical database management system.

  C. PostgreSQL is a network-type database management system.

  D. PostgreSQL is an XML database management system.

  E. PostgreSQL is a relational database management system.

  Correct Answer: E

• Question 110:

  Select the most suitable statement about the PostgreSQL license from below.

  A. PostgreSQL is distributed under the GPL license.

  B. PostgreSQL is distributed under the PostgreSQL license.

  C. PostgreSQL is distributed under the LGPL license.

  D. PostgreSQL is distributed under the BSD license.

  E. PostgreSQL is distributed under the X11(MIT) license.

  Correct Answer: D