PostgreSQL PGCES-02 Exam Practice Test Instant Access

Question 1

A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');

C10

D11

E-10

Answer : B

Question 2

The table "custom" is defined below. The "id" column and "introducer" column are of

INTEGER type, and the "email" column is of TEXT type.

id | email | introducer ---- +-----------------+-----------2 |

aaa@example.com | 1 3 |

bbb@example.com | 2 4 |

ccc@example.com | 2

Three SQL statements were executed in the following order:

INSERT INTO custom SELECT max(id) + 1, 'ddd@example.com', 4

FROM custom; UPDATE custom SET introducer = 999 WHERE email = 'bbb@example.com'; DELETE FROM custom WHERE introducer NOT IN (SELECT id FROM custom); Select the number of rows in the "custom" table after the execution.

A0 rows

B1 row

C2 rows

D3 rows

E4 rows

Answer : C

Question 3

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

ASELECT 'ABC' . 'abc';

BSELECT cat('ABC', 'abc') FROM pg_operator;

CSELECT 'ABC' + 'abc';

DSELECT 'ABC' + 'abc' FROM pg_operator;

ESELECT 'ABC' || 'abc';

Answer : E

Question 4

The "animal" table consists of the following data: Select the correct result returned by executing the following SQL statement: SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;

AA syntax error will occur.

Answer : A

Question 5

Select the most appropriate statement about the initdb command.

AIt can not be executed by an OS administrator-level user (root user).

BIt can only be executed by the user who installed PostgreSQL.

CUnless the environment variable PGDATA is set, it can not be executed.

DWhen 'auto' is designated as the value for the environment variable PGDATA, a directory is automatically set up.

EThe directory designated by the environment variable PGDATA must exist.

Answer : A

Question 6

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

Note: "text=#" is the command prompt for psql. test=# ANALYZE foo;

ACollects statistical information related to the content of the database foo.

BCollects statistical information related to the content of the table foo.

CCollects statistical information related to the content of the database test.

DOutputs statistical information related to the content of the table foo.

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

Answer : B

Question 7

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

AOnly a PostgreSQL superuser is authorized to create a new database.

BThe target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.

COnly one database can be used at the same time even if two or more databases are created.

DOnly the OS superuser (root) can create databases.

EYou can set the character encoding when creating a new database.

Answer : E

PostgreSQL CE 8 Silver PGCES-02 Exam Practice Test