Multiple choice technology databases

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

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

The standard implicit cursor attributes are %FOUND, %NOTFOUND, and %ROWCOUNT (along with %ISOPEN). In contrast, %rowtype is a data type declaration attribute rather than a cursor attribute, and %toomanyrows is a predefined exception.