Oracle
1Z0-144 · Question #84
1Z0-144 Question #84: Real Exam Question with Answer & Explanation
The correct answer is B. Each fetch retrieves the next consecutive row and assigns values to the target variables.. See the full explanation below for the reasoning.
Question
Examine the following PL/SQL code: Which statement is true about the fetch statements in the PL/SQL code?
Exhibit
Options
- AEach fetch retrieves the first row and assigns values to the target variables.
- BEach fetch retrieves the next consecutive row and assigns values to the target variables.
- CThey produce an error because you must close and reopen the cursor before each fetch -
- DOnly the first fetch retrieves the first row and assigns values to the target variables- the second
Community Discussion
No community discussion yet for this question.