In SQL, ROLLBACK is used to _________.
2017
In SQL, ROLLBACK is used to _________.
- A.
Undo all the previous changes
- B.
Cut changes
- C.
Paste changes
- D.
End changes
Attempted by 47 students.
Show answer & explanation
Correct answer: A
The correct option is A. In SQL, the ROLLBACK command is a Transaction Control Language (TCL) command used to undo uncommitted transactions. It reverts the database to its last committed state or a specific savepoint, completely erasing any pending modifications made during the current session.