Chapter 6, Problem 6.36RQ

Program Plan Intro

Transaction:

A transaction is a small set of changes which must be made to the database. The transaction done to the database may or may not affect the changes to the content of the database. The execution takes place as a single unit.

Transaction Isolation Level:

The transaction isolation level gives the measure of the extent to which transaction isolation succeeds.

• This process is defined by the presence or the absence of the phenomena such as dirty read, nonrepeatable reads, phantoms.
• These problems occur when we read data from the database.