Multiple choice sql

Which of the following are cursor attributes ?

  1. %ISOPEN

  2. %NOTFOUND

  3. both a and b

  4. %CURSORSOPEN
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PL/SQL cursors have attributes like %ISOPEN (checks if cursor is open) and %NOTFOUND (checks if the last fetch returned no rows). %CURSORSOPEN is not a valid cursor attribute. Other attributes include %FOUND and %ROWCOUNT.

Keep practicing — related questions