What do you mean by Repeatable Read?

Ads
 

What do you mean by Repeatable Read?

What do you mean by Repeatable Read?

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:
What do you mean by Repeatable Read?
What do you mean by Deadlock?
Advertisements
What do you mean by Read Committed?
What do you mean by Serialized?
What do you mean by Read Uncommitted?
What do you mean by platform independence?
What do you understand by JPA?
What do you understand by Domain Parking?
What do you understand by private, protected and public?
What do you understand by Kafka broker
What do you understand by Virtual Hosting?
What do you understand by Hibernate in Java?
what do you understand by big data and what are its basic components
What do you think about client-side/server-side coding ?
what is mean by setValidating() - Java Beginners
What do you understand by the are PHP, ASP and Perl languages?
what does business analyst mean
What does it mean that a class or member is final?
what session.flush() do ?
StringIndexOutOfBoundException problem, What is mean in this code | first.charAt(i)) |
StringIndexOutOfBoundException problem, What is mean in this code | first.charAt(i)) |
StringIndexOutOfBoundException problem, What is mean in this code | first.charAt(i)) |
What does COMMIT do?
what does mean of method("1") in below struts.xml file
What does the delete operator do?
What does the delete operator do?
How do you define a constant?
When you look back on the position you held last, do you think you have done your best in it?
Social Media Marketing: Do you really need it?
What do I need to do to use a MSSQL-Server with Web-Harvester?
What does a special set of tags <?= and ?> do in PHP?

Ads