PostgreSQL_CE

PGCES-02 · Question #55

Select one statement which will cause a syntax error.

The correct answer is B. SELECT * FROM (SELECT * FROM customer);. See the full explanation below for the reasoning.

Question

Select one statement which will cause a syntax error.

Options

ASELECT (SELECT item FROM sale WHERE id = 1);
BSELECT * FROM (SELECT * FROM customer);
CSELECT * FROM item
DSELECT * FROM sale
ESELECT * FROM sale

How the community answered

(29 responses)

A
3% (1)
B
83% (24)
C
3% (1)
E
10% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full PGCES-02 Practice