Multiple choice

Which three definitions are associated with implicit cursors?

  1. %rowtype, %toomanyrows, %found

  2. %found, %notfound, %rowcount

  3. %rowtype, %rowcount, %notfound

  4. None of the above

  5. All of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle PL/SQL implicit cursors (used in implicit SELECT statements and DML operations) have three key attributes: %FOUND (returns TRUE if a row was affected), %NOTFOUND (returns TRUE if no row was affected), and %ROWCOUNT (returns number of rows affected). %ROWTYPE is used for declaring record variables based on table structures, not as a cursor attribute. Option B correctly lists the three implicit cursor attributes.

Keep practicing — related questions