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

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 11:

  psql generated the following error message:

  psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connections on port 5432?

  Select two reasons that are NOT the cause of this error.

  A. Host "server.example.com" does not exist.
  B. The PostgreSQL server is not running on "server.example.com".
  C. The PostgreSQL server is not accepting TCP/IP connections on "server.example.com".
  D. The PostgreSQL server is running on a port other than 5432 on "server.example.com".
  E. The username and/or password are incorrect.
  A. Host "server.example.com" does not exist.
  E. The username and/or password are incorrect.

• Question 12:

  Select two correct descriptions about views.

  A. A view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.
  B. A view is a virtual table which does not exist.
  C. A view is created to simplify complicated queries.
  D. You can create a view with the same name as already existing tables.
  E. A view only exists while the postmaster is running, and is deleted when the postmaster stops.
  B. A view is a virtual table which does not exist.
  C. A view is created to simplify complicated queries.

• Question 13:

  What does the following command do? Choose the most appropriate statement from the selection below.

  Note: $ is the command prompt.

  $ pg_dump postgres > pgsql

  A. Writes a backup of the database postgres to the file pgsql.
  B. Writes a backup of the entire database cluster using user postgres to the file pgsql.
  C. Backs up the database postgres and writes an error message to the file pgsql.
  D. Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.
  E. Outputs all of the content of the database postgres to the screen using the user pgsql.
  A. Writes a backup of the database postgres to the file pgsql.

• Question 14:

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

• Question 15:

  Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

  A. It is defining a trigger "trigger_1".
  B. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
  C. The "write_log" function is called before 'UPDATE' takes place.
  D. 'UPDATE' is not executed if "write_log" returns NULL.
  E. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.
  A. It is defining a trigger "trigger_1".
  E. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.

• Question 16:

  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
  C. \copy company TO 'company.txt' DELIMITER ','

• Question 17:

  Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d

  A. Backs up the "b" database to the "c" file, and stores error messages to the "d" file.
  B. Backs up the "b" database to the "d" file.
  C. Backs up large objects.
  D. Backs up the "c" database to the "d" file as the "c" user.
  E. Creates a backup, which is restorable with the pg_restore command.
  A. Backs up the "b" database to the "c" file, and stores error messages to the "d" file.
  D. Backs up the "c" database to the "d" file as the "c" user.

• Question 18:

  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 on the client side with the following content:

  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
  E. \copy company TO company.txt CSV

• Question 19:

  I would like to check the privileges on the "items" table in psql. Select the most appropriate command.

  A. \a items
  B. \d items
  C. \t items
  D. \p items
  E. \z items
  E. \z items

• Question 20:

  Select two incorrect statements related to the command below. Note: $ is the command prompt. $ psql -U foo -c "COPY company TO stdout;" bar

  A. If the company table is not readable, an error occurs.
  B. The content of the company table is written into a file called 'stdout'.
  C. The content of the company table is output in TAB delimited format.
  D. An error occurs unless the user foo has administrator privileges.
  E. Connects to the database bar.
  B. The content of the company table is written into a file called 'stdout'.
  D. An error occurs unless the user foo has administrator privileges.