Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27340 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 jdbc api?
Name different methods for getting streams.
What is difference between odbc and jdbc?
Describe odbc?
What are the different types of JDBC drivers?
What is jdbc vs odbc?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
What are the three basic components of the odbc architecture?
List some new features available in jdbc 4.0?
What is createstatement method in java?
Is jdbc part of j2ee?
What are drivers available?
Is odbc an api?
How to set NULL values in JDBC PreparedStatement?
What is jdbc odbc bridge in java?
