What do you mean by Repeatable Read?

Ads

 
 

Share on Google+Share on Google+

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

What do you mean by Repeatable Read?

Ads
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,


Ads









Related Tutorials/Questions & Answers:
Advertisements

Ads

 
Advertisement null

Ads