Difference between Dirty, commited ,phantom,repeatable
reads?
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 is jdbc class forname?
What are the considerations for deciding on transaction boundaries?
What are the common tasks of JDBC?
How we store procedure in oralce for callable statements in jdbc
Can resultset be null in java?
What is data source in java?
How many ways can you update a result set?
How do you insert images into database using jdbc?
Is jdbc faster than hibernate?
What are the higher level apis under development on top of jdbc currently?
What is the meaning of batch updates?
Describe odbc?
Is jdbc secure?
Does jdbctemplate use prepared statements?
Which Java and java.sql data types map to my specific database types?