PostgreSQL_CE
PGCES-02 · Question #54
PGCES-02 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
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.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.