Multiple choice technology databases

Implicit cursors, process ... Choose all that apply

  1. All INSERT statements

  2. All DELETE statements

  3. All UPDATE statements

  4. Single row SELECT statements

  5. Multiple row SELECT statements

  6. Zero row SELECT statements
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Implicit cursors are automatically created by PL/SQL for all single-row DML operations (INSERT, UPDATE, DELETE) and single-row SELECT...INTO statements. Multi-row SELECT statements require explicit cursors with loops to process multiple rows.

Keep practicing — related questions