Multiple choice technology databases

Implicit cursors are declared for

  1. Some DML,PL/SQL statements

  2. All DML,PL/SQL statements

  3. Only PL/SQL statements

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Implicit cursors are automatically declared by Oracle for ALL DML statements (INSERT, UPDATE, DELETE) and PL/SQL SELECT INTO statements. They track the operation's results (%ROWCOUNT, %FOUND, etc.). Option B correctly states this.

Keep practicing — related questions