Which SQL statement is used to undo any changes made during the current transaction?

  • ROLLBACK
  • COMMIT
  • SELECT
  • DELETE
The ROLLBACK statement is used to undo any changes made during the current transaction. When a transaction encounters an issue or needs to be canceled for any reason, the ROLLBACK statement is issued to revert all the changes made during that transaction, ensuring data consistency and integrity. This is a fundamental part of the ACID (Atomicity, Consistency, Isolation, Durability) properties of database transactions.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *