Multiple choice technology databases

Auto commit occurs on

  1. On any DML

  2. On any DDL

  3. On both

  4. On none
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Autocommit occurs automatically when DDL (Data Definition Language) statements like CREATE, ALTER, DROP are executed. DML (Data Manipulation Language) statements like INSERT, UPDATE, DELETE require explicit COMMIT unless autocommit mode is specifically enabled. DDL statements cannot be rolled back in Oracle, which is why they trigger automatic commits.

Keep practicing — related questions