Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27141 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
Is possible to open a connection to a database with exclusive mode with JDBC?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
What are the considerations for deciding on transaction boundaries?
How can we move the cursor in a scrollable result set?
What is jdbc connection?
Which jdbc driver is the fastest driver?
What is a rollback in jdbc?
What is correlated subquery?
What is odbc. how is it related to sql cli?
State the different connection methods used for creating different types of sql.
Why prepared statements are faster?
How can we execute stored procedures using callablestatement?
What is JDBC Driver interface?
What is statement and preparedstatement in java?
What is jdbc explain?
