SQL - Transactions and Data Integrity
You want to insert multiple rows but only save some changes. Which command allows partial rollback within a transaction?
You want to insert multiple rows but only save some changes. Which command allows partial rollback within a transaction?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Understand partial rollback
SAVEPOINT marks a point in transaction; ROLLBACK TO SAVEPOINT undoes changes after that point.Step 2: Identify command for partial rollback
ROLLBACK TO SAVEPOINT allows undoing some changes without discarding entire transaction.Final Answer:
ROLLBACK TO SAVEPOINT -> Option AQuick Check:
Partial rollback = ROLLBACK TO SAVEPOINT [OK]
Quick Trick: Use ROLLBACK TO SAVEPOINT for partial undo [OK]
Common Mistakes:
- Using SAVEPOINT alone to rollback
- Confusing COMMIT with rollback
- 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