hemant kumar
What is dirty read?
1 Answer(s)      4 years and 6 months ago
Posted in : SQL

What is dirty read?

Advertisement
View Answers

November 15, 2010 at 3:21 PM


Hi,

Dirty read is caused when the TRANSACTION ISOLATION LEVEL is set to READ UNCOMMITTED. This isolation level neither issues a shared lock nor issues exclusive locks. The statements in the current transaction can modify the data that has not been committed by other transactions. It leads to the removal or change in the data before the completion of the current transaction. The shared and exclusive locks prevent the statements in the current transaction to read the data that has not been committed by other transactions.