Multiple choice technology databases

Which command will cause an automatic commit to occur?

  1. CONNECT

  2. RENAME

  3. INSERT

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

In SQL databases, DDL (Data Definition Language) commands like RENAME typically cause an automatic commit of the current transaction. DML commands like INSERT and DELETE don't auto-commit unless autocommit mode is enabled. CONNECT establishes a session but doesn't commit anything.

Keep practicing — related questions