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

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 51:

  Select the most suitable statement about the creation of a new database.

  A. Only a PostgreSQL superuser is authorized to create a new database.
  B. The target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.
  C. Only one database can be used at the same time even if two or more databases are created.
  D. Only the OS superuser (root) can create databases.
  E. You can set the character encoding when creating a new database.
  E. You can set the character encoding when creating a new database.

• Question 52:

  Select the most suitable statement about the PostgreSQL license from below.

  A. PostgreSQL is distributed under the GPL license.
  B. PostgreSQL is distributed under the PostgreSQL license.
  C. PostgreSQL is distributed under the LGPL license.
  D. PostgreSQL is distributed under the BSD license.
  E. PostgreSQL is distributed under the X11(MIT) license.
  D. PostgreSQL is distributed under the BSD license.

• Question 53:

  The table "score" is defined as follows:

  gid | score -----+------1 | 70 1 | 60 2 | 100 3 | 80 3 | 50

  The following query was executed. Select the number of rows in the result. SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;

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

• Question 54:

  From the SQL commands below, select one that is generally classified as "DDL".

  A. START TRANSACTION
  B. CREATE TABLE
  C. SELECT
  D. INSERT
  E. DELETE
  B. CREATE TABLE

• Question 55:

  Select two incorrect statements about the function of the information schema.

  A. It consists of a group of views included in a schema called "information_schema".
  B. Information on objects defined in a database can be referenced.
  C. The number of tables defined in a database can be confirmed.
  D. Administrator privileges are needed to reference the information schema.
  E. In order to enable the information schema, "information_schema = true" must be set in postgresql.conf
  D. Administrator privileges are needed to reference the information schema.
  E. In order to enable the information schema, "information_schema = true" must be set in postgresql.conf

• Question 56:

  Select one incorrect description regarding the following SQL statement defining a function. CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN) RETURNS SETOF TEXT LANGUAGE C STRICT SECURITY DEFINER AS 'myfuncs.so';

  A. This function may be defined in 'myfuncs.so'.
  B. This function can return multiple rows.
  C. This SQL statement defines a function written in the C language.
  D. If this function is called with a NULL parameter, it will return 0 when executed.
  E. This function operates with the authority of the user who executed it.
  E. This function operates with the authority of the user who executed it.

• Question 57:

  Select the SQL command that must be executed prior to executing the EXECUTE command.

  A. CREATE FUNCTION
  B. PREPARE
  C. DECLARE
  D. LOAD
  E. ALLOCATE
  B. PREPARE

• Question 58:

  The table "t1" is defined below.

  The column "id" for table "t1" is of INTEGER type.

  id | name

  ----+-----------1 | mammoth

  2 | tortoise

  3 | coelacanth

  The following SQL statements were executed. Select the correct statement about the execution result.

  BEGIN;

  DECLARE c SCROLL CURSOR FOR SELECT name FROM t1 ORDER BY id; MOVE FORWARD 2 FROM c;

  FETCH FORWARD ALL FROM c; COMMIT;

  A. The number of rows returned by the FETCH statement is 0.
  B. The number of rows returned by the FETCH statement is 1.
  C. The number of rows returned by the FETCH statement is 2.
  D. The number of rows returned by the FETCH statement is 3.
  E. An error occurs part way through.
  B. The number of rows returned by the FETCH statement is 1.

• Question 59:

  Select one incorrect statement from the below about a database cluster.

  A. It is possible to have multiple databases within a database cluster.
  B. A database cluster is created using initdb command.
  C. Each host can have only one database cluster.
  D. Special databases called template0 and template1 are created in a database cluster by default.
  E. When a database cluster is created, a database superuser is registered using the username of the OS at the time of creation unless otherwise designated.
  C. Each host can have only one database cluster.

• Question 60:

  Select the correct result generated by execution of the following SQL statements: CREATE TABLE log (id int, message TEXT, logtime TIMESTAMP); CREATE TABLE log_01 () INHERITS (log); INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP); SELECT * FROM log;

  A. First 'CREATE TABLE' generates a syntax error.
  B. Second 'CREATE TABLE' generates a syntax error.
  C. 'INSERT' statement generates an error stating that the number of columns and values do not match".
  D. 'SELECT' statement returns 0 rows, and exits successfully.
  E. 'SELECT' statement returns 1 row, and exits successfully.
  E. 'SELECT' statement returns 1 row, and exits successfully.