Multiple choice technology databases

Identify the CURSOR attribute that returns the number of rows fetched so far by the cursor?

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

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

The %ROWCOUNT attribute returns the number of rows fetched so far by an open cursor or affected by DML statements. In contrast, %FOUND and %NOTFOUND are boolean attributes indicating whether a row was fetched, and %ISOPEN returns a boolean indicating whether the cursor is open or closed.

Keep practicing — related questions