You need to process a large table sales in chunks of 50 rows using a cursor. Which code snippet correctly fetches 50 rows at a time?

hard📝 Application Q8 of 15

PostgreSQL - Advanced PL/pgSQL

You need to process a large table sales in chunks of 50 rows using a cursor. Which code snippet correctly fetches 50 rows at a time?

AOPEN cur; FETCH 50 ROWS FROM cur;

BOPEN cur; FETCH NEXT FROM cur LIMIT 50;

COPEN cur; FETCH ALL FROM cur WHERE rowcount=50;

DOPEN cur; FETCH FORWARD 50 FROM cur;

Step-by-Step Solution

Solution:

Step 1: Understand FETCH syntax
FETCH FORWARD n FROM cursor fetches n rows forward.
Step 2: Analyze options
OPEN cur; FETCH FORWARD 50 FROM cur; uses correct syntax to fetch 50 rows at once.
Step 3: Incorrect options
Options B, C, and D use invalid or unsupported syntax.
Final Answer:
OPEN cur; FETCH FORWARD 50 FROM cur; -> Option D
Quick Check:
FETCH FORWARD n fetches n rows [OK]

Quick Trick: Use FETCH FORWARD n to get n rows [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