Multiple choice technology databases

Which command or action causes an automatic rollback?

  1. GRANT

  2. EXIT at pl/sql prompt

  3. Alter command

  4. System crash

  5. Commit before a system crash
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

System crashes cause automatic rollback of uncommitted transactions to maintain database ACID properties. The UNDO logs are used to reverse any uncommitted changes. Normal SQL commands like GRANT, ALTER, or EXIT do not trigger rollbacks.

Keep practicing — related questions