Difference between Dirty, commited ,phantom,repeatable
reads?

Answers were Sorted based on User's Feedback



Difference between Dirty, commited ,phantom,repeatable reads?..

Answer / 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

Difference between Dirty, commited ,phantom,repeatable reads?..

Answer / manoj pandey

Check the following link for differences:
http://sqlwithmanoj.wordpress.com/2011/07/20/dirty-reads-and-phantom-reads/

Is This Answer Correct ?    4 Yes 1 No

Difference between Dirty, commited ,phantom,repeatable reads?..

Answer / sknkarthik

dirty read allow a row changed by one transation to be read
by another transaction before any changes have been commited.
non repeatable read is whre one transaction chage a row
another transaction alter or delete the row then the 1st
transacton reread the row with the different value in the
second time.
phantom read is whre one transcation read the row that
satisfied the where condiotion the the 2nd transcation
insert the row with the where condiotion then the 1st
transaction reread the satisfied the where condition get the
phantom row in the second time

Is This Answer Correct ?    8 Yes 8 No

Post New Answer

More JDBC Interview Questions

Why do we need jdbc driver?

0 Answers  


Explain the locking system in jdbc & its types?

0 Answers  


What is thin driver in jdbc?

0 Answers  


How to know howmuch data is truncated?

0 Answers   Mastek,


How many jdbc driver types are there?

0 Answers  






What is JDBC API and when do we use it?

0 Answers  


what is the difference between SENSITIVE and INSENSITIVE?

1 Answers  


What are jdbc?

0 Answers  


What is metadata in java programming?

0 Answers  


How does a custom RowSetReader get called from a CachedRowSet?

0 Answers  


Why resultset is used in java?

0 Answers  


What does jdbc setmaxrows method do?

0 Answers  


Categories