Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27207 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 jdbc connection string?
What is JDBC Statement?
What are the types of jdbc drivers that exist?
Explain the locking system in jdbc?
How can we maintain the integrity of a database by using jdbc?
What is jdbc stand for?
Why should we close database connections in java?
What are the considerations for deciding on transaction boundaries?
What is jdbc and odbc?
What does jdbc do?
If you are truncated using JDBC, how can you that how much data is truncated?
What class.forname will do while loading drivers of jdbc?
How data can be inserted into long row column of database?
What is difference between jdbc and odbc?
What is odbc and jdbc?
