Oracle
1Z0-146 · Question #135
Which two statements are true about cursor variables? (Choose two.)
The correct answer is D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied E. The OPEN FOR statement executes the query associated with a cursor variable and identifies. See the full explanation below for the reasoning.
Question
Which two statements are true about cursor variables? (Choose two.)
Options
- ACursor variables can be parameterized like cursors.
- BThe query associated with a cursor variable cannot reference host variables and PL/SQL variables.
- CThe FETCH statement executes the query associated with a cursor variable and identifies the
- DCursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied
- EThe OPEN FOR statement executes the query associated with a cursor variable and identifies
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C7% (2)
- D79% (23)
Community Discussion
No community discussion yet for this question.