PostgreSQL Exam PGCES-02 Topic 7 Question 16 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 16
Topic #: 7

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

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.

Show Suggested Answer

Suggested Answer: C

by Vallie at May 03, 2022, 07:26 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!