Explain Dirty Read in Database

Database Dirty Read

A Job Portal

Are you looking for a new Job ?
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