Multiple choice

Which of the following commands will cause an automatic commit to occur?

  1. CONNECT

  2. RENAME

  3. SELECT

  4. INSERT

  5. DELETE

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, the RENAME command performs an automatic commit because it is a DDL (Data Definition Language) operation. All DDL commands in Oracle have implicit commit behavior. Other options listed are either DML (INSERT, DELETE) or session commands (CONNECT, SELECT) which do not auto-commit.