What do you mean by Repeatable Read?

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,









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 docker container
What do you mean by platform independence?
What do you understand by JPA?
What do you learn in AI?
What do you understand by private, protected and public?
What do you understand by Kafka broker
What do you understand by Domain Parking?
What do you understand by Virtual Hosting?
What skills do you need for big data?
What do you understand by Hibernate in Java?
What courses do you take for data science?
what do you understand by big data and what are its basic components
what is mean by setValidating() - Java Beginners
ModuleNotFoundError: No module named 'readN'
What do you think about client-side/server-side coding ?
What do you understand by the are PHP, ASP and Perl languages?
What does it mean by Goldilocks effect?
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 the delete operator do?
What does the delete operator do?
what does mean of method("1") in below struts.xml file
How do you do data mining projects?
What do data scientists earn?
How do you define a constant?
How do you sum a dictionary
What do I need to do to use a MSSQL-Server with Web-Harvester?
Do you need math for AI?
What does a special set of tags <?= and ?> do in PHP?
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?
What can R do that Python can t?
What does a data scientist Do example?
What does a data scientist do daily?
What degree do data scientists have?
What skills do I need for machine learning?
What data scientists do all day work?
What skills do I need to be a data analyst?

Ads