Oracle
1Z0-146 · Question #30
Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)
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
How the community answered
(32 responses)- A84% (27)
- B6% (2)
- C9% (3)
Community Discussion
No community discussion yet for this question.