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

Oracle PL/SQL implicitly creates cursors for all DML statements (INSERT, UPDATE, DELETE, MERGE) and SELECT statements (which are PL/SQL statements). These implicit cursors handle the SQL processing automatically - you declare variables to receive the data, but the cursor itself is created implicitly. Option A is incorrect because it's not just 'some' but all statements. Option C is incorrect because implicit cursors are also created for DML, not just PL/SQL. Option D is incorrect because implicit cursors are indeed declared.

Keep practicing — related questions