PostgreSQL Exam PGCES-02 Topic 8 Question 57 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 57
Topic #: 8

[All PGCES-02 Questions]

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 Irma at Mar 21, 2024, 05:56 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Michael

6 months ago

I agree with you, Statement E is misleading in that regard.

upvoted 0 times

...

Val

6 months ago

I think statement E is incorrect because 'DEALLOCATE' does not deallocate prepared statements, but releases memory instead.

upvoted 0 times

...

Artie

6 months ago

That's a good point, 'PREPARE' and 'EXECUTE' commands serve other purposes too.

upvoted 0 times

...

Michael

6 months ago

I believe statement A is incorrect because 'PREPARE'/'EXECUTE' is not solely used for performance optimization.

upvoted 0 times

...

Val

6 months ago

I agree with you, Statement C is definitely incorrect.

upvoted 0 times

...

Artie

6 months ago

I think statement C is incorrect because 'PREPARE' can specify other statements like 'INSERT' or 'UPDATE'.

upvoted 0 times

...

Audrie

6 months ago

And 'DEALLOCATE' is used to free up resources allocated for prepared statements.

upvoted 0 times

...

Janet

6 months ago

Yes, and 'EXECUTE' then executes the plan created by 'PREPARE'.

upvoted 0 times

...

Cora

7 months ago

So, the correct statement would be that 'PREPARE' is not limited to just SELECT.

upvoted 0 times

...

Selma

7 months ago

I agree. 'PREPARE' can be used for INSERT, UPDATE, DELETE besides SELECT.

upvoted 0 times

...

Goldie

8 months ago

I believe you're right. 'PREPARE' can specify other statements too.

upvoted 0 times

...

Devora

8 months ago

I think statement C is incorrect.

upvoted 0 times

...