Multiple choice technology databases

When dealing with Cursor For Loops, which steps are taken care of implicitly? Choose all that apply

  1. DECLARE

  2. OPEN

  3. FETCH

  4. CLOSE

  5. PROCESS
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

In PL/SQL cursor FOR loops, the OPEN, FETCH, and CLOSE operations are handled automatically by the loop construct. The loop opens the cursor when entered, fetches each row iteratively, and closes the cursor when the loop completes or exits. The cursor must still be explicitly DECLARED, and the PROCESS step (loop body logic) is written by the developer.

Keep practicing — related questions