In a database transaction, what is the role of the "commit" operation?

  • To lock the database for exclusive access
  • To permanently apply the changes made in the transaction to the database
  • To retrieve data from the database
  • To undo the changes made in the transaction
The "commit" operation in a database transaction is responsible for permanently applying the changes made within the transaction to the database. Once a transaction is committed, the changes become visible to other transactions, and they are durably stored in the database, ensuring data persistence. Committing a transaction signifies that all its operations have been successfully completed and are ready to be made permanent.
Add your answer
Loading...

Leave a comment

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