Which two statements are true about cursor variables? (Choose two.)
A.
Cursor variables can be parameterized like cursors.
B.
The query associated with a cursor variable cannot reference host variables and PL/SQL
variables.
C.
The FETCH statement executes the query associated with a cursor variable and identifies the
result set.
D.
Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied
to a cursor variable.
E.
The OPEN FOR statement executes the query associated with a cursor variable and identifies
the result set.
D, E
D.
Usage Notes
You can apply the cursor attributes %FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT to a cursor variable.
E.
Usage Notes
You use three statements to control a cursor variable:
OPEN-FOR, FETCH, and CLOSE. First, you OPEN a cursor variable FOR a multi-row query.
Then, you FETCH rows from the result set. When all the rows are processed, you CLOSE the cursor variable.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/cursor_variables.htm