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



Home Answers Viewqa SQL What do you mean by Repeatable Read?

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What do you mean by Repeatable Read?
1 Answer(s)      3 years and 8 months ago
Posted in : SQL


What do you mean by Repeatable Read?


Advertisement
View Answers

November 19, 2010 at 12:50 PM


Hi,

The Repeatable Read isolation level allows a transaction to acquire read locks on all rows of data it returns to an application, and write locks on all rows of data it inserts, updates, or deletes.All data records read by a SELECT statement cannot be changed; however, if the SELECT statement contains any ranged WHERE clauses, phantom reads can occur. When it's used, the dirty reads and nonrepeatable reads cannot occur. It means that locks will be placed on all data that is used in a query, and another transactions cannot update the data.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com