PostgreSQL PGCES-02 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id);

A0 rows

B2 rows

C3 rows

D5 rows

E6 rows

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A0 rows

B2 rows

C3 rows

D5 rows

E6 rows

0 / 1500

Question 2

SQL statements were executed in the following order. CREATE TABLE book ( id VARCHAR(21), title TEXT NOT NULL, price INT, UNIQUE

(id), CHECK (price > 0) ); INSERT INTO book VALUES ('4-12345-678-

9', 'SQL book', 2300); --(1) INSERT INTO book (title, price) VALUES

('PostgreSQL', 3000); --(2) UPDATE book SET id = '4-12345-678-9'

WHERE id IS NULL; --(3) DELETE FROM book WHERE price < 0; --(4)

While executing, select the first location that generates an error.

A(1)

B(2)

C(3)

D(4)

ENo error is generated.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A(1)

B(2)

C(3)

D(4)

ENo error is generated.

0 / 1500

Question 3

Select one incorrect statement concerning the following SQL statement.

CREATE OR REPLACE VIEW sales_view AS SELECT * FROM sales_table ORDER BY sales_date DESC LIMIT 10;

ADefines the view called 'sales_view'.

BReplaces 'sales_view' if it already exists.

CWhen you 'SELECT' the 'sales_view', it displays the first 10 records from the 'sales_table' sorted by the 'sales_date' column in descending order.

DSome errors occur when 'SELECT * FROM sales_table' is executed after the view is defined.

EYou can confirm that the 'sales_view' has been added by querying the view called 'pg_views'.

Correct : D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ADefines the view called 'sales_view'.

BReplaces 'sales_view' if it already exists.

CWhen you 'SELECT' the 'sales_view', it displays the first 10 records from the 'sales_table' sorted by the 'sales_date' column in descending order.

DSome errors occur when 'SELECT * FROM sales_table' is executed after the view is defined.

EYou can confirm that the 'sales_view' has been added by querying the view called 'pg_views'.

0 / 1500

Question 4

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);

A2 rows

B3 rows

C4 rows

D5 rows

E6 rows

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A2 rows

B3 rows

C4 rows

D5 rows

E6 rows

0 / 1500

Question 5

Select two correct statements from below concerning the ANALYZE command.

AIt renews the statistical information of the table content.

BIt takes some time to execute, but it does not lock the table.

CIf the FULL option is used when executing, the size of the file can be reduced.

DIf ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

EIf ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.

Correct : A, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt renews the statistical information of the table content.

BIt takes some time to execute, but it does not lock the table.

CIf the FULL option is used when executing, the size of the file can be reduced.

DIf ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

EIf ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.

0 / 1500

Master PostgreSQL PGCES-02 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: