Answers:
Transaction commit is responsible for
making all the data modifications permanent in the database. When transaction
commit occurs the following are the observations:
- A commit record to indicate the modifications as
permanent is written to the log.
- Depending upon the type of commit the log
information in memory is simultaneously written to disk.
- Locks are released. This means the modifications
can be viewable.