In the use of an explicit cursor,which 3 statements replace the FOR statement of an implicit cursor?
A) OPEN, FIND, and CLOSE.
B) OPEN, FETCH, and CLOSE.
C) OPEN, GET, and CLOSE.
D) CONNECT, FIND, and CLOSE.

Question

Quizplus · Accepted Answer

In the use of an explicit cursor, the three statements that replace the FOR statement of an implicit cursor are OPEN, FETCH, and CLOSE. 
- OPEN: This statement opens the cursor and sets up the SQL statement that will be executed when the cursor is FETCHed.
- FETCH: This statement retrieves the next row from the result set that the cursor has opened. This statement is executed repeatedly until all rows have been retrieved.
- CLOSE: This statement closes the cursor and releases the resources used by the cursor.

In the Use of an Explicit Cursor,which 3 Statements Replace