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

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 1:

  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)
  B. '10 day'::interval

• Question 2:

  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);
  B. INSERT INTO foo VALUES ('5000000000');
  D. INSERT INTO foo VALUES (2000000000);

• Question 3:

  Select two transaction isolation levels supported in PostgreSQL.

  A. DIRTY READ
  B. READ COMMITTED
  C. REPEATABLE READ
  D. PHANTOM READ
  E. SERIALIZABLE
  B. READ COMMITTED
  E. SERIALIZABLE

• Question 4:

  Select the correct SQL statement to define a new data type.

  A. CREATE CLASS
  B. CREATE FUNCTION
  C. CREATE OPERATOR
  D. CREATE DATABASE
  E. CREATE TYPE
  E. CREATE TYPE

• Question 5:

  You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction. Select one answer containing the correct keyword(s) to fill in the underlined blank below. DECLARE cursor1 FOR SELECT * FROM customer;

  A. CURSOR
  B. SCROLL CURSOR WITH HOLD
  C. INSENSITIVE CURSOR
  D. NO SCROLL CURSOR WITH HOLD
  E. CURSOR WITHOUT HOLD
  B. SCROLL CURSOR WITH HOLD

• Question 6:

  The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT * FROM sample WHERE v ~ 'ab';

  A. 0 rows
  B. 1 row
  C. 2 rows
  D. 3 rows
  E. 4 rows
  C. 2 rows

• Question 7:

  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();
  A. SELECT version;

• Question 8:

  It is possible to backup a database cluster by copying the entire data directory. Select two suitable descriptions regarding this backup method.

  A. The backup data will be a text file consisting of SQL statements.
  B. The database server must be stopped prior to the backup.
  C. The "pg_restore" command is used to restore the database.
  D. "psql" is used to restore the database.
  E. You can use standard tools like "tar" and "rsync" to backup files and directories.
  B. The database server must be stopped prior to the backup.
  E. You can use standard tools like "tar" and "rsync" to backup files and directories.

• Question 9:

  The following are statements related to the postmaster. Select one statement that is incorrect.

  A. postmaster is a server process that receives connections from clients.
  B. The "pg_ctl start" command boots up postmaster.
  C. It is not possible to boot up the postmaster process by directly executing the postmaster command.
  D. One postmaster process controls one database cluster.
  E. The "pg_ctl stop" command stops postmaster.
  C. It is not possible to boot up the postmaster process by directly executing the postmaster command.

• Question 10:

  The "animal" table consists of the following data:Select the correct result returned by executing the following SQL statement: SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;

  A. A syntax error will occur.
  A. A syntax error will occur.