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

Fabiola

7 days ago

I'm going with Option E. Selecting from both tables where the IDs match, and including the data column. Looks good to me!

upvoted 0 times

...

Kattie

13 days ago

Hold up, I think Option D might be the one. Trying to select from both tables where the IDs match, but the data column doesn't exist in sample2.

upvoted 0 times

...

Vivan

20 days ago

Option A seems straightforward enough. Why would that cause an error?

upvoted 0 times

...

Mireya

20 days ago

Why do you think option C will cause an error?

upvoted 0 times

...

Dwight

24 days ago

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

upvoted 0 times

...

Mireya

27 days ago

I think option D will cause an error.

upvoted 0 times

...