Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27190 Views
- I also Faced
- E-Mail Answers
Answer Posted / bawa
- Dirty read—Dirty reads occur when one transaction reads data that has been written but not yet committed by another transaction. If the changes are later rolled back, the data obtained by the first transaction will be invalid.
- Nonrepeatable read—Nonrepeatable reads happen when a transaction performs the same query two or more times and each time the data is different. This is usually due to another concurrent transaction updating the data
between the queries.
- Phantom reads—Phantom reads are similar to nonrepeatable reads. These occur when a transaction (T1) reads several rows, and then a concurrent transaction (T2) inserts rows. Upon subsequent queries, the first transaction (T1) finds additional rows that were not there before.
| Is This Answer Correct ? | 29 Yes | 2 No |
Post New Answer View All Answers
What is the use of the statement in jdbc?
How can I manage special characters when I execute an insert query?
Explain the difference between rowset vs. Resultset in jdbc?
Why do we need a jdbcrowset like wrapper around resultset?
What are the differences between statement and preparedstatement interface?
What is thin driver in jdbc?
How do I set properties for a JDBC driver and where are the properties stored?
When do we use execute method in java jdbc?
What is jdbc odbc driver?
What is dburl?
Is jdbc a protocol?
What is the full form of jdbc and what is its purpose?
What is resultsetmetadata?
What is correlated subquery?
How to retrieve warnings in jdbc?
