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

• Question 41:

  Select one incorrect statement concerning the following SQL statement. CREATE OR REPLACE VIEW sales_view AS SELECT * FROM sales_table ORDER BY sales_date DESC LIMIT 10;

  A. Defines the view called "sales_view".

  B. Replaces "sales_view" if it already exists.

  C. When you 'SELECT' the "sales_view", it displays the first 10 records from the "sales_table" sorted by the "sales_date" column in descending order.

  D. Some errors occur when "SELECT * FROM sales_table" is executed after the view is defined.

  E. You can confirm that the "sales_view" has been added by querying the view called "pg_views".

  Correct Answer: D

• Question 42:

  What does the following command do? Choose the most appropriate statement from the selection below.

  Note: $ is the command prompt.

  $ pg_dump postgres > pgsql

  A. Writes a backup of the database postgres to the file pgsql.

  B. Writes a backup of the entire database cluster using user postgres to the file pgsql.

  C. Backs up the database postgres and writes an error message to the file pgsql.

  D. Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.

  E. Outputs all of the content of the database postgres to the screen using the user pgsql.

  Correct Answer: A

• Question 43:

  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.

  Correct Answer: C

• Question 44:

  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.

  Correct Answer: BE

• Question 45:

  Select two incorrect statements related to the command below. Note: $ is the command prompt. $ psql -U foo -c "COPY company TO stdout;" bar

  A. If the company table is not readable, an error occurs.

  B. The content of the company table is written into a file called 'stdout'.

  C. The content of the company table is output in TAB delimited format.

  D. An error occurs unless the user foo has administrator privileges.

  E. Connects to the database bar.

  Correct Answer: BD

• Question 46:

  I want to restore data from a text format backup file foo.dump. Select an appropriate command.

  A. pg_dump -R foo < foo.dump

  B. pg_restore -d foo foo.dump

  C. pg_restore -f foo.dump foo

  D. psql -f foo.dump foo

  E. createdb foo < foo.dump

  Correct Answer: D

• Question 47:

  Select the most suitable statement about PostgreSQL from below.

  A. There are PostgreSQL GPL license versions and commercial license versions.

  B. You need to be pre-registered to use PostgreSQL.

  C. PostgreSQL can be used by everyone free of charge for any purpose, be it private, commercial, or academic.

  D. You can use PostgreSQL for free; however, the source code is not open to the public.

  E. PostgreSQL is shareware.

  Correct Answer: C

• Question 48:

  Based on the relationship of columns within a table, select the most suitable description that shows that column A is dependent on column B.

  A. The value in column B is uniquely determined when a value in column A is selected.

  B. The value in column A is uniquely determined when a value in column B is selected.

  C. When the value in column A is changed, the corresponding value in column B also must be changed.

  D. When the value in column B is changed, the corresponding value of column A also must be changed.

  E. As long as column B exists, the amount of information will not decrease even if column A is deleted.

  Correct Answer: B

• Question 49:

  The following question concerns the use of multibyte characters in PostgreSQL. Select two correct items about character encoding in PostgreSQL.

  A. "./configure --enable-multibyte" must be designated at time of build.

  B. When the database cluster is initialized, the or --multibyte option must be specified.

  C. Character encoding can be set on a per database basis.

  D. Only a single character encoding can be specified for each database cluster.

  E. Different character encodings can be specified for server and clients.

  Correct Answer: CE

• Question 50:

  What phenomenon occurs if PostgreSQL is used without performing VACUUM ? Select two appropriate descriptions from those below.

  A. Performance is reduced.

  B. It gradually gets to the point where connections are denied.

  C. The physical size of the database increases considerably in size.

  D. Only SELECT queries will be accepted.

  E. An e-mail prompting the administrator to perform VACUUM is sent from PostgreSQL.

  Correct Answer: AC