Multiple choice technology databases

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

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

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

%NOTFOUND evaluates to TRUE when a FETCH operation fails to return a row (no more rows), and FALSE when at least one row is successfully returned. This attribute is commonly used to check if a cursor has exhausted its rows after a fetch operation. %FOUND does the opposite (TRUE when a row is found).

Keep practicing — related questions