Multiple choice technology databases

Identify the CURSOR attribute that evaluates to TRUE if cursor is OPEN?

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

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

%ISOPEN is a cursor attribute that returns TRUE if the cursor is currently open and FALSE if it is closed. This is useful for checking cursor state before attempting operations that require an open cursor. The other attributes track row existence (%FOUND/%NOTFOUND) or row count (%ROWCOUNT).

Keep practicing — related questions