Multiple choice technology programming languages

Which command 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

RENAME is a DDL command and DDL commands cause implicit commits before and after execution. CONNECT, SELECT, INSERT, and DELETE do not cause automatic commits - they are DDL (CONNECT) or DML (SELECT, INSERT, DELETE) that require explicit COMMIT. The implicit commit with RENAME happens even if the user has uncommitted changes.

Keep practicing — related questions