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



Home Answers Viewqa SQL What do you mean by Read Committed?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What do you mean by Read Committed?
1 Answer(s)      4 years and a month ago
Posted in : SQL


What do you mean by Read Committed?


Advertisement
View Answers

November 19, 2010 at 12:26 PM


Hi,

Data records retrieved by a query are not prevented from modification by some other transactions. Non-repeatable reads may occur, meaning data retrieved in a SELECT statement may be modified by some other transaction when it commits.

The Read Committed isolation level allows a transaction to acquire a read lock (if it only reads the data) or a write lock (if it updates or deletes data) on the current row of data it is working with. This means the row of data being used by the transaction can not be changed or removed by other transactions until the lock is terminated.

thanks,



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com