Multiple choice technology databases

The life cycle of the explicit cursor goes through _______ stages:

  1. Declare, Open, Close

  2. Declare, Open, Fetch, Close

  3. Declare, Open, Fetch, Close, Remove

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An explicit cursor in PL/SQL has four lifecycle stages: DECLARE (defines the cursor in the declaration section), OPEN (executes the query and identifies the active set), FETCH (retrieves rows one at a time), and CLOSE (releases the active set and frees resources). Remove is not a standard cursor stage.

Keep practicing — related questions