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

• Question 111:

  Select one incorrect statement regarding psql.

  A. psql is an interactive SQL interpreter that enables a user to enter queries.

  B. For system security, only the PostgreSQL administrator account is allowed to use psql.

  C. "psql -l" displays a database list.

  D. "psql -U jan" will connect to the database called jan.

  E. Commands that begin with a backslash are processed internally in psql.

  Correct Answer: B

• Question 112:

  I would like to insert the contents of the text file users.dat into the table t1 using psql. Contents of text file

  users.dat:

  Definition of table t1:

  CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input from those

  below.

  A. \copy t1 FROM users.dat WITH DELIMITER ':'

  B. \copy t1 TO users.dat WITH DELIMITER ':'

  C. INSERT INTO t1 FROM file('users.dat');

  D. INSERT INTO t1 SELECT uname, pass, id FROM file('users.dat');

  E. \insert t1 FROM users.dat WITH DELIMITER ':';

  Correct Answer: A

• Question 113:

  Select one correct statement about the createlang command.

  A. It is a command for setting the locale for a database.

  B. It is a command for registering a procedural language into a database.

  C. It is a command for creating a user defined function.

  D. It is a command for adding message catalogs.

  E. It is a command that has been discarded for version 8 and later.

  Correct Answer: B

• Question 114:

  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.

  Correct Answer: AD

• Question 115:

  Select two suitable statements about major version upgrades of PostgreSQL from below.

  A. You can use the databases of the old major version.

  B. To use the data from the old version, you only need to replace the program.

  C. To use the data from the old version, you need to conduct a backup and restore.

  D. There is a possibility of configuration parameter changes after major version upgrades.

  E. Upgrade scripts can be executed while the old version of PostgreSQL is running.

  Correct Answer: CD

• Question 116:

  Select one incorrect statement concerning the relational data model.

  A. It expresses the real world in a collection of 2-dimensional tables called a relation.

  B. It is a model based on set theory.

  C. It has a logical structure independent of physical data structure.

  D. It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.

  E. It is a model that was proposed by E.F. Codd in 1970.

  Correct Answer: D

• Question 117:

  Select two incorrect statements concerning PostgreSQL license.

  A. It can be used freely.

  B. It can be duplicated freely.

  C. It can be freely redistributed.

  D. Developers are responsible for its maintenance support.

  E. Developers are only responsible for handling its crucial faults.

  Correct Answer: DE

• Question 118:

  Four SQL statements were executed in the following order. CREATE TABLE foo (bar INT); ALTER TABLE foo ALTER bar TYPE BIGINT; ALTER TABLE foo ADD baz VARCHAR(5); ALTER TABLE foo DROP bar; Select two SQL statements that generate an error when executed.

  A. INSERT INTO foo VALUES ('12345');

  B. INSERT INTO foo VALUES ('5000000000');

  C. INSERT INTO foo VALUES ('ABC');

  D. INSERT INTO foo VALUES (2000000000);

  E. INSERT INTO foo VALUES (NULL);

  Correct Answer: BD

• Question 119:

  A table named "sample" is defined as below. Select two statements which will generate a constraint error.

  CREATE TABLE sample (

  i INTEGER PRIMARY KEY, j INTEGER,

  CHECK ( i > 0 AND j < 0 )

  );

  A. INSERT INTO sample VALUES (1, 0);

  B. INSERT INTO sample VALUES (2, -2);

  C. INSERT INTO sample VALUES (3, NULL);

  D. INSERT INTO sample VALUES (NULL, -4);

  E. INSERT INTO sample VALUES (5, -5);

  Correct Answer: AD

• Question 120:

  The following is the result of executing the createlang command which is installed with PostgreSQL.

  $ createlang -U postgres --list mydb

  Procedural Languages

  Name | Trusted?

  ---------+---------- plpgsql | yes

  Select two correct statements from below.

  A. The procedural language plpgsql is installed in the database mydb using the above command.

  B. The procedural language plpgsql can be used in the database mydb.

  C. plpgsql is a trusted language, so it can execute the OS commands on the server side.

  D. plpgsql is a trusted language, so it can read/write OS files on the server side.

  E. plpgsql is a safe language with restricted operations.

  Correct Answer: BE