Intermediate
SQL
Q46 / 100
What does a transaction with "COMMIT" and "ROLLBACK" provide?
Correct! Well done.
Incorrect.
The correct answer is B) A way to group multiple statements so they either all succeed (COMMIT) or all be undone (ROLLBACK), ensuring atomicity
B
Correct Answer
A way to group multiple statements so they either all succeed (COMMIT) or all be undone (ROLLBACK), ensuring atomicity
Explanation
Transactions allow a sequence of operations to be treated as a single atomic unit: COMMIT makes all changes permanent, while ROLLBACK reverts all changes made since the transaction began.
Progress
46/100