Multiple choice technology databases

Identify the CURSOR attribute that evaluates to TRUE if cursor returns at least 1 row?

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

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

The %FOUND cursor attribute evaluates to TRUE if the most recent FETCH statement returned at least one row. %NOTFOUND evaluates to TRUE if no rows were returned, %ROWCOUNT returns the number of rows, and %ISOPEN checks if the cursor is open.

Keep practicing — related questions