Examine the following PL/SQL code: Which statement is true about the fetch statements in the PL/SQL code?

Question

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

• A
  3% (1)
• B
  82% (28)
• C
  6% (2)
• D
  9% (3)

No community discussion yet for this question.