Multiple choice technology databases

What are the Sql Cursor Attributes in Pl/sql?

  1. SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

  2. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

  3. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The correct SQL cursor attributes in PL/SQL are: SQL%ROWCOUNT (number of rows affected), SQL%FOUND (boolean, true if at least one row affected), SQL%NOTFOUND (boolean, true if no rows affected), and SQL%ISOPEN (boolean, always false for implicit cursors). Option B incorrectly uses SQL%OPEN, and Option A incorrectly uses SQL%ISFOUND.

Keep practicing — related questions