Oracle
1Z0-146 · Question #30
Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)
Options
- AWhen fetching from a cursor, fetch into a record.
- BWhen fetching from a cursor, fetch required values into individually declared variables.
- CWhenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements
- DWhenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using
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.