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

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 131:

  What does the following command do? Choose two incorrect statements from the selection below.

  Note: $ is the command prompt.

  $ pg_restore -U postgres -d database1 database1.dump

  A. This command restores the database database1 from the file database1.dump.
  B. This command connects to a database as the user 'postgres'.
  C. This command can not be executed unless the postmaster is running.
  D. This command can not restore large objects.
  E. This command must be executed under the condition where the database database1 does not exist.
  D. This command can not restore large objects.
  E. This command must be executed under the condition where the database database1 does not exist.

• Question 132:

  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.
  C. When SELECT is executed to the table, the specified function can be called.
  E. A corresponding rule is automatically created when a trigger is created.

• Question 133:

  Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.

  A. VACUUM
  B. VACUUM ANALYZE
  C. EXPLAIN
  D. EXPLAIN ANALYZE
  E. NOTIFY
  B. VACUUM ANALYZE

• Question 134:

  Select the most suitable statement about PostgreSQL from below.

  A. PostgreSQL is a card-type database management system.
  B. PostgreSQL is a hierarchical database management system.
  C. PostgreSQL is a network-type database management system.
  D. PostgreSQL is an XML database management system.
  E. PostgreSQL is a relational database management system.
  E. PostgreSQL is a relational database management system.

• Question 135:

  Table "t1" is defined as follows:

  CREATE TABLE t1 (value VARCHAR(5));

  A set of SQL statements were executed in the following order. Select the number of rows that table "t1" has after execution.

  BEGIN;

  INSERT INTO t1 VALUES ('AA'); SAVEPOINT point1;

  INSERT INTO t1 VALUES ('BB'); SAVEPOINT point2;

  INSERT INTO t1 VALUES ('CC'); ROLLBACK TO point1;

  INSERT INTO t1 VALUES ('DD'); END;

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

• Question 136:

  The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2". Select a correct keyword to fill in the blank below. SELECT * FROM t1 SELECT * FROM t2;

  A. EXCEPT
  B. UNION
  C. NAND
  D. INTERSECT
  E. INTERSECT ALL
  A. EXCEPT

• Question 137:

  Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.

  A. pg_ctl stop
  B. pg_ctl -m fast stop
  C. pg_ctl -m immediate stop
  D. pg_ctl -m wait stop
  E. pg_ctl -s stop
  A. pg_ctl stop

• Question 138:

  A table is defined as below. Select the most suitable description about the foreign key constraint. CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE record (id INTEGER REFERENCES master (id), count INTEGER);

  A. If any row exists in the "record" table, no change can be made to the "master" table.
  B. If the "record" table contains a row with an "id", no change can be made at all to the corresponding "id" row in the "master" table.
  C. If the "record" table contains a row with an "id", the corresponding "id" row in the "master" table cannot be deleted.
  D. The "record" table cannot have duplicate "id"s.
  E. These SQL statements are invalid; no constraints are created.
  C. If the "record" table contains a row with an "id", the corresponding "id" row in the "master" table cannot be deleted.

• Question 139:

  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.
  B. The procedural language plpgsql can be used in the database mydb.
  E. plpgsql is a safe language with restricted operations.

• Question 140:

  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.
  B. For system security, only the PostgreSQL administrator account is allowed to use psql.