![EBK DATABASE CONCEPTS](https://www.bartleby.com/isbn_cover_images/9780133777840/9780133777840_largeCoverImage.gif)
Concept explainers
Transaction:
A transaction is a small set of changes which must be made to the
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 like dirty read, non-repeatable reads, phantoms.
- These problems occur while reading the data from the database.
Dirty Read:
A dirty read occurs when a transaction reads data from a row which has been changed, but the changes made to the data have not been committed. When the changes have been rolled back, the transition holds an incorrect data.
“Non-repeatable” Read:
The non-repeatable read occurs when a transaction reads data from the same row twice; but gets different data each time. It returns different row values or shows that the row has been deleted.
Phantom read:
A phantom read occurs when transaction reads the data again and discovers new rows which have been inserted by a committed transaction.
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 6 Solutions
EBK DATABASE CONCEPTS
- EBK JAVA PROGRAMMINGComputer ScienceISBN:9781337671385Author:FARRELLPublisher:CENGAGE LEARNING - CONSIGNMENT
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337671385/9781337671385_smallCoverImage.jpg)