Oracle
1Z0-146 · Question #120
Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.)
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Design Considerations for PL/SQL Code
Question
Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.)
Options
- AWhen fetching from a cursor, fetch into a record.
- BUse parameters with cursors so that the result set for the cursor is not tied to a specific variable in a
- CUse the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non
- DWhenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE statements
- EWhen using data manipulation language statements, (DML) reference a SQL cursor attribute immediately
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#cursor design#parameterized cursors#cursor attributes#record fetch