The ____ action used with an explicit cursor clears the active set of rows and frees the memory area used for the cursor.
A) CLOSE
B) OPEN
C) DECLARE
D) FETCH

Question

Quizplus · Accepted Answer

The CLOSE action is used with an explicit cursor to release the hold on the cursor and clear the active set of rows. It also frees the memory area used for the cursor. Therefore, option A is the best choice.

The ____ Action Used with an Explicit Cursor Clears the Active