SQL - Transactions and Data Integrity
Which SQL command reverses all modifications made in the current transaction before they are saved?
Which SQL command reverses all modifications made in the current transaction before they are saved?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify undo command
ROLLBACK cancels all changes made in the current transaction.Step 2: Difference from COMMIT
COMMIT saves changes permanently; ROLLBACK discards them.Final Answer:
ROLLBACK -> Option BQuick Check:
ROLLBACK undoes changes before commit [OK]
Quick Trick: ROLLBACK cancels uncommitted changes [OK]
Common Mistakes:
- Confusing COMMIT with ROLLBACK
- Using SAVEPOINT to undo entire transaction
- Thinking BEGIN TRANSACTION undoes changes
Master "Transactions and Data Integrity" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes