Oracle
1Z0-146 · Question #30
1Z0-146 Question #30: Real Exam Question with Answer & Explanation
The correct answer is A. When fetching from a cursor, fetch into a record. D. Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.