Multiple choice technology

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

Implicit cursors are automatically created for SQL DML statements in PL/SQL. Their available attributes are %FOUND, %notfound, %ROWCOUNT, and %ISOPEN. %ROWTYPE is used for variable declarations matching a record structure, not cursor operations, and %TOOMANYROWS is not a standard attribute.

Keep practicing — related questions