Dirty Read in Database Interview Question

57 views · Published 29 January 2014 · 1:45 · Indexed 26 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. Dirty Read in Database Interview Question

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.


Dirty Read in Database Interview Question

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

More from this channel