PostgreSQL PGCES-02 PostgreSQL CE 8 Silver Exam Practice Test

Page: 1 / 14
Total 142 questions
Question 1

Select two correct statements from below concerning the ANALYZE command.



Answer : A, D


Question 2

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.



Answer : B


Question 3

Select two statements that the command below DOES NOT do.

Note: $ is the command prompt. $ pg_dump -b -F c b > d



Answer : A, D


Question 4

Select one SQL statement that will cause an error.



Answer : A


Question 5

Select one statement which will cause a syntax error.



Answer : B


Question 6

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 ('A'); SAVEPOINT sp; INSERT INTO t1 VALUES ('B'); ROLLBACK TO sp; INSERT INTO t1 VALUES ('C'); COMMIT;



Answer : B


Question 7

A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);



Answer : C


Page:    1 / 14   
Total 142 questions