PostgreSQL-CE PostgreSQL-CE Certifications PGCES-02 Questions & Answers

• Question 61:

  Select two incorrect statements concerning the system catalog.

  A. It stores the object definition information for tables and columns.

  B. There may be changes to specification by major version upgrades.

  C. It is accessible as a table; however, it is output in binary format so it can not be read as is.

  D. It stores the internal information of the database management system.

  E. It is defined based on the standard SQL specification.

  Correct Answer: CE

• Question 62:

  What does the following command do? Select the correct description from below. Note:

  "text=#" is the command prompt for psql.

  test=# ANALYZE foo;

  A. Collects statistical information related to the content of the database foo.

  B. Collects statistical information related to the content of the table foo.

  C. Collects statistical information related to the content of the database test.

  D. Outputs statistical information related to the content of the table foo.

  E. The command does not generate an error; however, it does not do anything either.

  Correct Answer: B

• Question 63:

  Select two suitable statements about the BSD license from below.

  A. If you make changes to the source code, feedback must be sent to the original developers.

  B. It is used by open source software.

  C. User registration is required.

  D. It is defined by Free Software Foundation, Inc. (FSF).

  E. Software under the BSD license can be incorporated with any programs provided that the copyright notice appears in all copies.

  Correct Answer: BE

• Question 64:

  Which normal form has the constraint that there must be no tables with duplicate column values in the same row?

  A. First normal form

  B. Second normal form

  C. Third normal form

  D. Boyce/Codd normal form

  E. Fourth normal form

  Correct Answer: A

• Question 65:

  Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.

  A. SAVEPOINT function was added.

  B. Point-In-Time Recovery function was added.

  C. The shared buffer control algorithm was improved.

  D. Two-phase commit function was added.

  E. CSV mode was added to the copy command.

  Correct Answer: D

• Question 66:

  Select one false statement about the benefits of using database management systems from below.

  A. You can separate the data storage method from the application.

  B. You can separate the data search method from the application.

  C. You can separate the data display method from the application.

  D. You can reduce the programming workload of programming for managing data.

  E. You can share data more easily on systems consisting of multiple computers.

  Correct Answer: C

• Question 67:

  Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

  A. This is a backup method integrating a physical backup and a transaction log (WAL).

  B. It is necessary to stop the database server to perform a backup for the first time.

  C. Updated data is continuously saved.

  D. A restore can be performed to any arbitrary point in time since the starting point of PITR.

  E. A backup can only be performed on a per-database basis.

  Correct Answer: BE

• Question 68:

  Select one incorrect description about changing the settings of PostgreSQL during operation.

  A. The current value of a parameter can be confirmed using the SHOW command.

  B. All of the current settings can be displayed using the SHOW ALL command.

  C. Changes that can be made using the SET command have higher priority than ones in postgresql.conf.

  D. Values set by a superuser using the SET command are valid for different connections made later.

  E. There are parameters that can not be set using the SET command

  Correct Answer: D

• Question 69:

  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

  Correct Answer: E

• Question 70:

  Select two appropriate statements from below about the following SQL statements: CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS ' DECLARE x ALIAS FOR $1; r text := ''default''; BEGIN IF x > 100 THEN SELECT INTO r data FROM mytable WHERE id = x; END IF; RETURN r; END;';

  A. An error is generated unless the plpgsql language is registered in the database beforehand.

  B. The execution results of SELECT myfunc(-123) differs based on the content of "mytable".

  C. When SELECT myfunc(123) is executed an error occurs.

  D. When SELECT myfunc(NULL) is executed an error occurs.

  E. When SELECT myfunc (0) is executed the text "default" is returned.

  Correct Answer: AE