Multiple choice technology databases

which of the following is not an explicit cursor attribute

  1. %notfound

  2. %rowcount

  3. %isopen

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

The four explicit cursor attributes in PL/SQL are: %ISOPEN (checks if cursor is open), %FOUND (checks if last fetch returned a row), %NOTFOUND (opposite of %FOUND), and %ROWCOUNT (returns number of rows fetched). %ISCLOSE is not a valid cursor attribute - there is no such attribute in Oracle PL/SQL.

AI explanation

To answer this question, we need to understand the concept of explicit cursor attributes in Oracle.

Explicit cursors are used to retrieve and manipulate data from a query. They have certain attributes that can provide information about the cursor. The available explicit cursor attributes in Oracle are:

A) %NOTFOUND - This attribute returns TRUE if the last fetch did not return a row, and FALSE otherwise.

B) %ROWCOUNT - This attribute returns the number of rows fetched so far from the cursor.

C) %ISOPEN - This attribute returns TRUE if the cursor is open, and FALSE otherwise.

D) %ISCLOSE - This attribute is not a valid explicit cursor attribute in Oracle. Therefore, option D is the correct answer.

The correct answer is D) %ISCLOSE, as it is not an explicit cursor attribute in Oracle.

Keep practicing — related questions