PostgreSQL Exam PGCES-02 Topic 9 Question 29 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 29
Topic #: 9

Given the following two table definitions, select one SQL statement which will cause an error. CREATE TABLE sample1 (id INTEGER, data TEXT); CREATE TABLE sample2 (id INTEGER);

ASELECT s1.id FROM sample1 s1;

BSELECT s1.id FROM sample1 AS s1;

CSELECT data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = 1 AND s2.id = 2;

DSELECT id, data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;

ESELECT s1.id, s1.data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;

Show Suggested Answer

Suggested Answer: A

by Lezlie at Jul 25, 2022, 01:44 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dwight

2 days ago

I disagree, I believe option C is the one that will cause an error.

upvoted 0 times

...

Mireya

5 days ago

I think option D will cause an error.

upvoted 0 times

...