PostgreSQL PGCES-02 Exam Practice Test Instant Access

Question 1

What does the following command do? Choose one incorrect statement from the selection below.

$ pg_dumpall -U postgres > 20060601.bak

ABackup all the databases in a database cluster.

BBackup postgresql.conf along with databases.

CBackup with plain-text format.

DBackup user and group information along with databases.

EYou can access databases while the backup is in process.

Answer : B

Question 2

The following table called company is defined as follows:

id | name ----+--------

---------- 1 |

Pgsql,inc. 2 |

Postgres Co.,Ltd 3 |

SQL Company.

Select the most appropriate psql command for generating a text file company.txt with the following content on the client side. 1,Pgsql \,inc. 2,Postgres Co. \,Ltd 3,SQL Company.

A\copy company TO 'company.txt' WITH ',';

B\copy company TO 'company.txt' WITH DELIMITER AS ',';

C\copy company TO 'company.txt' DELIMITER ','

D\copy company TO 'company.txt'

E\copy company TO company.txt CSV

Answer : C

Question 3

Select two incorrect statements regarding 'TRIGGER'.

AWhen UPDATE is executed to the table, the specified function can be called.

BWhen INSERT is executed to the table, the specified function can be called.

CWhen SELECT is executed to the table, the specified function can be called.

DA trigger can be set up to call a specified function before or after the event occurs.

EA corresponding rule is automatically created when a trigger is created.

Answer : C, E

Question 4

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

ABOOLEAN is an alias of the INTEGER type in PostgreSQL.

BBOOLEAN only takes either NULL, TRUE, or FALSE.

CYou can use the characters 't' or 'f' as a value for the BOOLEAN type.

DYou can use the TRUE or FALSE keywords as a value for the BOOLEAN type.

EIf the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALSE.

Answer : A, E

Question 5

Select one incorrect statement about schemas.

AA schema is the name space for a database object.

BA new schema is created by 'CREATE SCHEMA'.

COne user cannot own multiple schemas.

D'SELECT current_schema();' returns the current schema.

E'DROP SCHEMA' deletes a schema.

Answer : C

Question 6

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

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

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

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

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

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

Answer : B

Question 7

Select the most suitable statement about PostgreSQL from below.

AThere are PostgreSQL GPL license versions and commercial license versions.

BYou need to be pre-registered to use PostgreSQL.

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

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

EPostgreSQL is shareware.

Answer : C

PostgreSQL PGCES-02 PostgreSQL CE 8 Silver Exam Practice Test