Oracle
1Z0-146 · Question #120
1Z0-146 Question #120: Real Exam Question with Answer & Explanation
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.
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.