Why is it important to CLOSE a cursor after use in PostgreSQL?

hard📝 Conceptual Q10 of 15

PostgreSQL - Advanced PL/pgSQL

ATo automatically commit transactions

BTo delete the underlying table

CTo release resources and avoid memory leaks

DTo reset the database connection

Step-by-Step Solution

Solution:

Step 1: Understand cursor resource usage
Cursors hold server resources like memory and locks while open.
Step 2: Importance of closing
Closing a cursor frees these resources to prevent leaks and improve performance.
Final Answer:
To release resources and avoid memory leaks -> Option C
Quick Check:
Closing cursor = free resources [OK]

Quick Trick: Always CLOSE cursors to free resources [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free