Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is dirty read?

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is dirty read?
1 Answer(s)      3 years and 9 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.



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com