PostgreSQL-CE PGCES-02 Online Practice Questions and Exam Preparation

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 31:

  Select two suitable statements about the BSD license from below.

  A. If you make changes to the source code, feedback must be sent to the original developers.
  B. It is used by open source software.
  C. User registration is required.
  D. It is defined by Free Software Foundation, Inc. (FSF).
  E. Software under the BSD license can be incorporated with any programs provided that the copyright notice appears in all copies.
  B. It is used by open source software.
  E. Software under the BSD license can be incorporated with any programs provided that the copyright notice appears in all copies.

• Question 32:

  I would like to be able to save log entries as shown below. Select a correct configuration setting from statements below.

  LOG: connection received: host=[local] port=

  LOG: connection authorized: user=postgres database=test

  A. syslog = true
  B. log_connections = true
  C. log_authorization = true
  D. log_hostname = true
  E. log_min_level = log
  B. log_connections = true

• Question 33:

  What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;

  A. Requests a list of defined tables in the currently connected database.
  B. Requests a list of defined tables in the "information_schema" database.
  C. Requests the contents of the "tables" table in the "information_schema" database.
  D. Requests the contents of the "tables" table in the "information_schema" schema.
  E. Requests a list of defined tables in the "information_schema" schema.
  A. Requests a list of defined tables in the currently connected database.
  D. Requests the contents of the "tables" table in the "information_schema" schema.

• Question 34:

  Select a correct SQL command to change existing user "george"'s password to "foobar".

  A. ALTER USER george WITH PASSWORD 'foobar';
  B. ALTER USER george CHANGE PASSWORD 'foobar';
  C. ALTER USER george SET PASSWORD 'foobar';
  D. SET USER george PASSWORD TO 'foobar';
  E. SET USER george ALTER PASSWORD 'foobar';
  A. ALTER USER george WITH PASSWORD 'foobar';

• Question 35:

  Select two commands below from which privileges cannot be changed by the GRANT and REVOKE statements.

  A. SELECT
  B. VACUUM
  C. DELETE
  D. TRIGGER
  E. DROP
  B. VACUUM
  E. DROP

• Question 36:

  Select two incorrect statements regarding 'DOMAIN'.

  A. When defining a domain, you can add a default value and constraints to the original data.
  B. Domain is a namespace existing between databases and objects such as tables.
  C. A domain is created by 'CREATE DOMAIN'.
  D. A domain can be used as a column type when defining a table.
  E. To define a domain, both input and output functions are required.
  B. Domain is a namespace existing between databases and objects such as tables.
  E. To define a domain, both input and output functions are required.

• Question 37:

  Select two SQL statements which abort a transaction.

  A. END
  B. ROLLBACK
  C. TRUNCATE
  D. ABORT
  E. DROP TRANSTACTION
  B. ROLLBACK
  D. ABORT

• Question 38:

  Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az

  A. Recovers unused areas from all of the databases.
  B. Collects statistical information related to the table content for all of the databases.
  C. Processes the job equivalent of the VACUUM FULL command for all of the databases.
  D. Processes the job equivalent of the VACUUM VERBOSE command for all of the databases.
  E. The database can not be accessed until this command is finished.
  A. Recovers unused areas from all of the databases.
  B. Collects statistical information related to the table content for all of the databases.

• Question 39:

  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".
  C. This command removes database foodb.
  E. The same process can be performed using the SQL command "DROP DATABASE".

• Question 40:

  Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.

  A. SAVEPOINT function was added.
  B. Point-In-Time Recovery function was added.
  C. The shared buffer control algorithm was improved.
  D. Two-phase commit function was added.
  E. CSV mode was added to the copy command.
  D. Two-phase commit function was added.