Oracle Database: Advanced PL/SQL — Question 19

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

Answer options

• A. Implicit cursor returns only one record.
• B. Explicit cursor can return more than one record.
• C. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
• D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
• E. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
• F. %Isopen is always false in Explicit Cursor.
• G. %Isopen is always false in Implicit Cursor.

Correct answer: B, D, G

Explanation

The correct answer includes B, D, and G. Explicit cursors are designed to handle multiple records, as stated in option B. Option D correctly lists the attributes of an Explicit Cursor. Option G is accurate because %Isopen is indeed false for Implicit Cursors, which always manage a single record. The other options either misrepresent the attributes or functionalities of cursors.