Oracle
1Z0-146 · Question #23
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 the. 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 the
How the community answered
(20 responses)- A5% (1)
- B10% (2)
- C15% (3)
- D70% (14)
Community Discussion
No community discussion yet for this question.