Which of the following statements is NOT true for Rollback statements in SQL?
2013
Which of the following statements is NOT true for Rollback statements in SQL?
- A.
All savepoints marked after the savepoint to which you rolled back, are erased.
- B.
It does not free any resources held by the transaction.
- C.
The savepoint to which you rollback is not erased.
- D.
The Rollback statement will erase all data modifications made from the start of the transaction to the savepoint.
Attempted by 611 students.
Show answer & explanation
Correct answer: D
ROLLBACK in SQL is a Transaction Control Language (TCL) command used to undo changes in a transaction that have not been committed to the database. It undoes changes only up to the specified savepoint (or to the last commit), not necessarily all changes from the start to that savepoint as stated.