Multiple choice technology databases

The life cycle of the explicit cursor goes through __________stages:

  1. Declare, Open, Close

  2. Declare, Open, Fetch, Close

  3. None

  4. Declare, Open, Fetch, Close, Remove
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An explicit cursor in PL/SQL has four lifecycle stages: DECLARE (define cursor), OPEN (execute query), FETCH (retrieve rows), and CLOSE (release resources). The Remove stage doesn't exist - closing is sufficient.

Keep practicing — related questions