PostgreSQL_CE

PGCES-02 · Question #54

Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.

The correct answer is C. 'PREPARE' can only specify 'SELECT' as a prepared statement. See the full explanation below for the reasoning.

Question

Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.

Options

A'PREPARE'/'EXECUTE' is mainly used to optimize performance.
B'PREPARE' creates a plan for the prepared statement.
C'PREPARE' can only specify 'SELECT' as a prepared statement.
D'EXECUTE' executes the plan defined by 'PREPARE'.
E'DEALLOCATE'deallocates prepared statements.

How the community answered

(44 responses)

A
5% (2)
B
2% (1)
C
75% (33)
D
11% (5)
E
7% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full PGCES-02 Practice