Home » PL/SQL MCQs

There are 4 steps to work on Explicit Cursor:

89. There are 4 steps to work on Explicit Cursor:

1. Declare the cursor to be initialized in memory.
2. Allocate memory by opening the cursor.
3. Retrieve data by fetching the cursor.
4. Release allocated memory by closing the cursor.

Select the correct order of the above 4 steps to work on Explicit Cursor.

1. II > III > IV > I
2. I > II > IV > III
3. I > II > III > IV
4. IV > III > II > I

Answer: C) I > II > III > IV

Explanation:

This is the order in which 4 steps will be performed to work on Explicit Cursor:

1. Declare the cursor to be initialized in memory.
2. Allocate memory by opening the cursor.
3. Retrieve data by fetching the cursor.
4. Release allocated memory by closing the cursor.