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 platform independence?
What do you understand by JPA?
Advertisements
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 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 ?
ModuleNotFoundError: No module named 'readN'
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 mean of method("1") in below struts.xml file
What do I need to do to use a MSSQL-Server with Web-Harvester?
Social Media Marketing: Do you really need it?
What does hadoop fsck command do?
What does hadoop fsck command do?
what does a technical business analyst do
what is java and why do i need it?
How do you add a numerical value to a regex
Java web development, what skills do I need?
Java web development, what skills do I need?
How do you map Java Objects with Database tables?
Mean by Bean Scope
What do we need to study to become a data scientist?
What skills you need to become a data scientist?

Ads