Multiple choice technology databases

Explicit Cursor attributes

  1. %Found

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

All four are valid explicit cursor attributes in PL/SQL. %FOUND returns TRUE if the last fetch returned a row. %NOTFOUND is the opposite. %ROWCOUNT counts rows fetched so far. %ISOPEN indicates whether the cursor is currently open. These attributes are essential for controlling cursor-based processing.

Keep practicing — related questions