Oracle

1Z0-147 · Question #53

Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

The correct answer is C. SQL%FOUND. See the full explanation below for the reasoning.

Question

Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

Options

ASQL%ISOPEN
BSQL%ROWCOUNT
CSQL%FOUND
DThis task cannot be accomplished with a SQL cursor attribute.
EA SQL cursor attribute cannot be used within a PL/SQL loop.

How the community answered

(56 responses)

A
13% (7)
B
2% (1)
C
79% (44)
D
5% (3)
E
2% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-147 Practice