Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 26984 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 are the different types of resultset?
What are the conditions applies to varchar variable, when using in procedures?
What is jdbc odbc connection?
Is jdbc an api?
How can you create jdbc statements?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
What is com mysql jdbc driver?
What is database deadlock ?
What types of DataSource objects are specified in the Optional Package?
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
How do I find ojdbc jar version?
Which is better jpa or jdbc?
What is jsp and jdbc?
How to test jdbc connection to sql server?
What are the steps required to execute a query in jdbc?
