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

• Question 11:

  Select two commands used to check the syntax of the ALTER TABLE statement in psql.

  A. \h ALTER TABLE

  B. \h ALTER

  C. \ ALTER TABLE

  D. \ ALTER

  E. HELP ALTER TABLE;

  Correct Answer: AB

• Question 12:

  Select one incorrect statement from the below about a database cluster.

  A. It is possible to have multiple databases within a database cluster.

  B. A database cluster is created using initdb command.

  C. Each host can have only one database cluster.

  D. Special databases called template0 and template1 are created in a database cluster by default.

  E. When a database cluster is created, a database superuser is registered using the username of the OS at the time of creation unless otherwise designated.

  Correct Answer: C

• Question 13:

  Select one SQL statement that will cause an error.

  A. SELECT version;

  B. SELECT current_user;

  C. SELECT current_date;

  D. SELECT current_timestamp;

  E. SELECT current_database();

  Correct Answer: A

• Question 14:

  Select two incorrect statements regarding 'TRIGGER'.

  A. When UPDATE is executed to the table, the specified function can be called.

  B. When INSERT is executed to the table, the specified function can be called.

  C. When SELECT is executed to the table, the specified function can be called.

  D. A trigger can be set up to call a specified function before or after the event occurs.

  E. A corresponding rule is automatically created when a trigger is created.

  Correct Answer: CE

• Question 15:

  The following table called company is defined as follows:

  id | name

  ----+-----------------1 | Pgsql,inc.

  2 | Postgres Co.,Ltd

  3 | SQL Company.

  Select the most appropriate psql command for generating a text file company.txt with the following content

  on the client side.

  1,Pgsql \,inc.

  2,Postgres Co. \,Ltd

  3,SQL Company.

  A. \copy company TO 'company.txt' WITH ',';

  B. \copy company TO 'company.txt' WITH DELIMITER AS ',';

  C. \copy company TO 'company.txt' DELIMITER ','

  D. \copy company TO "company.txt"

  E. \copy company TO company.txt CSV

  Correct Answer: C

• Question 16:

  What does the following command do? Choose one incorrect statement from the selection below. $ pg_dumpall -U postgres > 20060601.bak

  A. Backup all the databases in a database cluster.

  B. Backup postgresql.conf along with databases.

  C. Backup with plain-text format.

  D. Backup user and group information along with databases.

  E. You can access databases while the backup is in process.

  Correct Answer: B

• Question 17:

  Select one incorrect statement about the SQL COPY command.

  A. It copies data between a file and a table.

  B. You can output the row data of a table to a specified client side file.

  C. Copies row data from a file into a table.

  D. Only the superuser can specify the output file name.

  E. The delimiter that separates column data can be changed from the default TAB character.

  Correct Answer: B

• Question 18:

  Select two incorrect statements about the function of the information schema.

  A. It consists of a group of views included in a schema called "information_schema".

  B. Information on objects defined in a database can be referenced.

  C. The number of tables defined in a database can be confirmed.

  D. Administrator privileges are needed to reference the information schema.

  E. In order to enable the information schema, "information_schema = true" must be set in postgresql.conf

  Correct Answer: DE

• Question 19:

  Given the following two table definitions, select one SQL statement which will cause an error.

  CREATE TABLE sample1 (id INTEGER, data TEXT);

  CREATE TABLE sample2 (id INTEGER);

  A. SELECT s1.id FROM sample1 s1;

  B. SELECT s1.id FROM sample1 AS s1;

  C. SELECT data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = 1 AND s2.id = 2;

  D. SELECT id, data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;

  E. SELECT s1.id, s1.data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;

  Correct Answer: D

• Question 20:

  A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 UNION ALL SELECT * FROM t2;

  A. 2 rows

  B. 3 rows

  C. 4 rows

  D. 5 rows

  E. An error will occur.

  Correct Answer: D