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

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 101:

  Select three SQL statements which return NULL.

  A. SELECT 0 = NULL;
  B. SELECT NULL != NULL;
  C. SELECT NULL IS NULL;
  D. SELECT NULL;
  E. SELECT 'null'::TEXT;
  A. SELECT 0 = NULL;
  B. SELECT NULL != NULL;
  D. SELECT NULL;

• Question 102:

  Select two suitable statements about sequences.

  A. A sequence always returns a 4-byte INTEGER type value, so the maximum value is 2147483647.
  B. A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.
  C. Although the "nextval" function is called during a transaction, it will have no effect if that transaction is rolled back.
  D. A sequence always generates 0 or consecutive positive numbers.
  E. A sequence number can be set by calling the "setval" function.
  B. A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.
  E. A sequence number can be set by calling the "setval" function.

• Question 103:

  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.
  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.

• Question 104:

  Select two suitable statements regarding a postmaster process.

  A. A postmaster process waits for client connection requests.
  B. A postmaster process receives and processes database queries.
  C. A postmaster process creates a child process which processes the given queries.
  D. A postmaster process collects statistical information.
  E. A postmaster process is created for each client connection.
  A. A postmaster process waits for client connection requests.
  C. A postmaster process creates a child process which processes the given queries.

• Question 105:

  You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.

  A. DELETE product WHERE name ~ '2004';
  B. DELETE product WHERE contain(name, '2004');
  C. DELETE FROM product WHERE name IN '2004';
  D. DELETE FROM product WHERE name LIKE '%2004%';
  E. DELETE FROM product WHERE name SIMILAR TO '2004';
  D. DELETE FROM product WHERE name LIKE '%2004%';

• Question 106:

  Select two correct statements from below concerning the ANALYZE command.

  A. It renews the statistical information of the table content.
  B. It takes some time to execute, but it does not lock the table.
  C. If the FULL option is used when executing, the size of the file can be reduced.
  D. If ANALYZE is insufficient, the most efficient search plan will not be selected for queries.
  E. If ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.
  A. It renews the statistical information of the table content.
  D. If ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

• Question 107:

  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 ':';
  A. \copy t1 FROM users.dat WITH DELIMITER ':'

• Question 108:

  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.
  B. Backup postgresql.conf along with databases.

• Question 109:

  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.
  C. pg_dump can create a backup while postmaster is running.
  E. pg_dump can create a backup of a specified table.

• Question 110:

  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.
  D. Developers are responsible for its maintenance support.
  E. Developers are only responsible for handling its crucial faults.