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

• Question 91:

  Select one option which cannot be specified using createdb.

  A. Database locale

  B. Character encoding

  C. Host name

  D. Database owner

  E. Template database

  Correct Answer: A

• Question 92:

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

  A. This change will take effect as soon as postgresql.conf is saved.

  B. This change will take effect by executing "pg_ctl reload".

  C. This change will take effect by executing "pg_ctl restart".

  D. This change will take effect after rebooting the OS, because the new option is recorded as an OS parameter.

  E. This setting is invalid unless the change is made while postmaster is stopped.

  Correct Answer: C

• Question 93:

  Select two suitable statements regarding the pg_dump command.

  A. pg_dump is an SQL command.

  B. Only the user who executed initdb can execute pg_dump.

  C. pg_dump can create a backup while postmaster is running.

  D. pg_dump can create a backup while postmaster is stopped.

  E. pg_dump can create a backup of a specified table.

  Correct Answer: CE

• Question 94:

  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 A. initdb --locale=EUC_JP --no-encoding

  B. initdb --default-encoding=EUC_JP

  C. pg_ctl init --locale=EUC_JP

  D. initdb --encoding=EUC_JP --no-locale

  E. pg_ctl init --encoding=EUC_JP

  Correct Answer: D

• Question 95:

  Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.

  A. VACUUM

  B. VACUUM ANALYZE

  C. EXPLAIN

  D. EXPLAIN ANALYZE

  E. NOTIFY

  Correct Answer: B

• Question 96:

  A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');

  A. 0

  B. 1

  C. 10

  D. 11

  E. -10

  Correct Answer: B

• Question 97:

  A table and view are defined as follows:

  CREATE TABLE item (id INT, name TEXT, description TEXT); CREATE VIEW item_simple AS SELECT

  id, name FROM item;

  A set of SQL statements were executed in the order below. Select the most appropriate statement

  concerning the execution results.

  BEGIN;

  SELECT * FROM item_simple;

  INSERT INTO item_simple VALUES (1, 'item_name_1'); UPDATE item_simple SET name =

  'item_name_2' WHERE id = 1; DELETE FROM item_simple;

  END;

  A. An error is generated at the point the SELECT statement is executed.

  B. An error is generated at the point the INSERT statement is executed.

  C. An error is generated at the point the UPDATE statement is executed.

  D. An error is generated at the point the DELETE statement is executed.

  E. No error is generated.

  Correct Answer: B

• Question 98:

  The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17

  12:00:00'.

  Select the correct expression to fill in the blank below.

  SELECT CURRENT_TIMESTAMP::timestamp + ;

  A. '10 day'::timestamp

  B. '10 day'::interval

  C. 10::day

  D. 8640000::time

  E. age(8640000)

  Correct Answer: B

• Question 99:

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

  A. The directory must be copied after stopping the database server.

  B. When using the Tablespace function, it is necessary to back up the directory that stores the tablespace as well.

  C. A database cluster that has been restored can be used on a separate machine with the same structure.

  D. A database cluster that has been restored can be used on a newer version of PostgreSQL.

  E. A database cluster that has been restored can be used on an older version of PostgreSQL.

  Correct Answer: DE

• Question 100:

  Select the correct command to collect and save the statistical information of a table.

  A. ANALYZE

  B. CLUSTER

  C. REINDEX

  D. STATISTIC COLLECTION

  E. STATISTIC COLLECTOR

  Correct Answer: A