Oracle
1Z0-144 · Question #70
Which two statements are true about the usage of the cursor for loops? (Choose two.)
The correct answer is B. The implicit open, fetch, exit, and close of the cursor happen. D. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor. See the full explanation below for the reasoning.
Question
Which two statements are true about the usage of the cursor for loops? (Choose two.)
Options
- AThe cursor needs to be closed after the iteration is complete.
- BThe implicit open, fetch, exit, and close of the cursor happen.
- CThe record type must be explicitly declared to control the loop.
- DThe PL/SQL creates a record variable with the fields corresponding to the columns of the cursor
How the community answered
(50 responses)- A12% (6)
- B82% (41)
- C6% (3)
Community Discussion
No community discussion yet for this question.