Multiple choice

_____________ can be declared by us for the queries that return more than one row.

  1. Implicit cursors

  2. Explicit cursors

  3. REF cursor

  4. Normal cursor
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Explicit cursors must be declared by developers for queries that return multiple rows. Implicit cursors are automatically created by Oracle for single-row queries (like SELECT...INTO). REF cursors are cursor variables used to pass result sets, not a standard cursor type.

Keep practicing — related questions