Multiple choice technology programming languages

The structure of simple explicit cursor is

  1. open cursor; ---some statements close;

  2. open cursor; fetch into variables; ---some statements close cursor;

  3. open cursor; fetch into variables; ---some statements close;

  4. All of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct structure of an explicit cursor is: OPEN cursor, FETCH cursor INTO variables, process the data, then CLOSE cursor. Option B correctly shows this complete lifecycle with FETCH statement included.