Discuss PostgreSQL PGCES-02 Exam Topic 9 Question 51

Select one statement which will cause a syntax error.

ASELECT (SELECT item FROM sale WHERE id = 1);

BSELECT * FROM (SELECT * FROM customer);

CSELECT * FROM item WHERE cid IN
(SELECT cid FROM customer);

DSELECT * FROM sale WHERE name IN
(SELECT name FROM names);

ESELECT * FROM sale WHERE cid = ANY
(SELECT cid FROM customer);

Suggested Answer: B

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

17 comments · newest first

Gabriele 10 months ago

C and D look fine to me, no errors there!

Sherman 11 months ago

Wait, are you sure about A? Seems weird.

Wilda 11 months ago

Totally agree, A is definitely off.

Rosann 11 months ago

I think B is the one that's wrong.

Roselle 11 months ago

A will cause a syntax error.

Malcolm 12 months ago

I’m leaning towards option B too, but I’m not completely confident. It just seems off compared to the others.

Lottie 12 months ago

I practiced a similar question last week, and I think option A is fine, but B might throw an error.

Timmy 12 months ago

I'm not entirely sure, but I feel like all the other options are valid. Maybe I should double-check the syntax rules for subqueries.

Veda 1 year ago

I think option B looks suspicious because I remember something about not being able to select from a subquery directly like that.

Merilyn 1 year ago

This is tricky, I'm going to have to really focus and double-check my work. I don't want to miss something obvious.

Sabra 1 year ago

I've seen questions like this before. I think I know the common syntax errors to watch out for in subqueries and nested selects.

Noah 1 year ago

Hmm, I'm a bit unsure about this one. I'll need to carefully review each statement to make sure I don't miss anything.

Tamesha 1 year ago

This looks like a pretty straightforward SQL syntax question. I'm feeling confident I can spot the syntax error here.

Nettie 1 year ago

Okay, let me think this through step-by-step. I need to identify which statement has a syntax issue, not just which one is correct.

Laticia 1 year ago

Hmm, I'm not entirely sure about the difference between the two outcomes. I'll need to think this through carefully.

Tashia 1 year ago

This is a good example of a question that tests our understanding of data manipulation functions. I feel pretty confident that option A is the correct answer, as it follows the expected syntax for the "rename" function. The other options have some issues with the way they're structured.

Marsha 1 year ago

This seems similar to that question we did on customer financing options in class. I think the key is applying the correct rates based on income and credit score.

PostgreSQL PGCES-02 Exam - Topic 9 Question 51 Discussion