What is Dirty Read

481 views · Published 29 January 2014 · 2:05 · Indexed 28 September 2026

Channel: Interview DOT · 2014 · Science & Technology

Watch on YouTube

Click here - https://www.youtube.com/channel/UCd0U_xlQxdZynq09knDszXA?sub_confirmation=1 to get notifications. Explain Dirty Read in Database

Database   Dirty Read

A Job Portal
http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com
One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm

Are you looking for a new Job ?
InterviewDot.com - A Job Portal
http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com
One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm
What is "Dirty Read" in Database ? Interview Question And Answer ?

What is "Dirty Read" in Database ? 

Dirty Read occurs when a transaction reads data from a row that has been modified by another transaction,but 
has not yet commited.




                     "Read from database"                                                                  "Modify the data in database"






We come across the situation wherein one transaction can change a value, and a second transaction can read this 
value before the original change has been committed or rolled back. This is known as a dirty read scenario 
because there is always the possibility that the first transaction may rollback the change, resulting in the second 
transaction having read an invalid value.




Database   Dirty Read

Explain Dirty Read in Database

More from this channel