Question No. 1

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

AAn index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.

BBy using an index effectively, searching and sorting performs faster.

CThere are B-tree, Hash, R-tree and GiST index types.

DBy creating an index, performance always improves.

ECreating an unused index does not affect the performance of a database at all.

Show Answer

Correct Answer: D, E

Question No. 2

Table "t1" is defined as follows: CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order. Select the number of rows that table "t1" has after execution. BEGIN; INSERT INTO t1 VALUES ('AA'); SAVEPOINT point1; INSERT INTO t1 VALUES ('BB'); SAVEPOINT point2; INSERT INTO t1 VALUES ('CC'); ROLLBACK TO point1; INSERT INTO t1 VALUES ('DD'); END;

A1 row

B2 rows

C3 rows

D4 rows

E0 rows

Show Answer

Correct Answer: B

Question No. 3

A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all 172.16.1.0/24 md5 When user foo connects to database bar from host IP address 172.16.1.2, I would like password verification to not be performed. Select one appropriate line for the new pg_hba.conf file.

AAdd 'host foo bar 172.16.1.2/32 trust' to the first row.

BAdd 'host bar foo 172.16.1.2/32 trust' to the first row.

CAdd 'host foo bar 172.16.1.2/32 trust' to the last row.

DAdd 'host bar foo 172.16.1.2/32 trust' to the last row.

EThe settings are fine as is.

Show Answer

Correct Answer: B

Question No. 4

Select the most suitable statement regarding PostgreSQL's pg_hba.conf configuration file.

AYou can use any number of authentication types on a single line.

BYou cannot set different authentications per user.

CYou can set different authentications per table.

DThe authentication settings in the file are evaluated from the top line to the bottom line.

Ekrb5 authentication can only be used for local connections.

Show Answer

Correct Answer: D

Question No. 5

Select three SQL statements which return NULL.

ASELECT 0 = NULL;

BSELECT NULL != NULL;

CSELECT NULL IS NULL;

DSELECT NULL;

ESELECT 'null'::TEXT;

Show Answer

Correct Answer: A, B, D

Free PostgreSQL PGCES-02 Exam Actual Questions

The questions for PGCES-02 were last updated On Dec 18, 2024