Which two statements are true about cursor variables? (Choose two.)
A.
A cursor variable points to the current row in the result set of a multirow query stored in a work
area.
B.
A cursor variable is an explicitly named work area in which the results of different multirow
queries can be stored.
C.
A cursor variable can be used only if a query is performed and its results are processed in the
same subprogram.
D.
A cursor variable can be used to perform a query in one subprogram, and process the results
in a different subprogram.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#i7106
“Like a cursor, a cursor variable points to the current row in the result set of a multi-row query. A cursor variable is more flexible because it is not tied to a specific query. You can open a cursor variable for any query that returns the right set of columns.”
“Cursor variables are like pointers to result sets. You use them when you want to perform a query in one subprogram, and process the results in a different subprogram (possibly one written in a different language).”
So it’s A and D.
A , D