PostgreSQL PGCES-02 Exam Practice Test Instant Access

Question 1

Select two suitable statements regarding a postmaster process.

AA postmaster process waits for client connection requests.

BA postmaster process receives and processes database queries.

CA postmaster process creates a child process which processes the given queries.

DA postmaster process collects statistical information.

EA postmaster process is created for each client connection.

Answer : A, C

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

I would like to check the privileges on the "items" table in psql. Select the most appropriate command.

A\a items

B\d items

C\t items

D\p items

E\z items

Answer : E

Question 7

Select an appropriate command to check the PostgreSQL version in psql.

A\server_version

BSELECT version;

CSELECT version();

DSHOW version;

ESHOW server;

Answer : C

PostgreSQL PGCES-02 PostgreSQL CE 8 Silver Exam Practice Test