Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27139 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the different types of drivers under jdbc?
How do I know which jdbc driver to use?
How do I connect to jdbc?
What is transaction processing in jdbc?
What is the role of the jdbc drivermanager class?
What is jdbc resultsetmetadata interface?
What is JDBC Savepoint? How to use it?
Is there another way of dealing with the result set that could execute faster?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
What is JDBC RowSet? What are different types of RowSet?
How do I set properties for a JDBC driver and where are the properties stored?
How can I retrieve a String or other object type without creating a new object each time?
How to move the cursor in scrollable resultset ?
What is serialization and deserialization in java programming?
How to check jdbc driver version in sql server?
