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
Why we use while rs next ())?
Is possible to open a connection to a database with exclusive mode with JDBC?
What is jdbc connection string?
What does executeupdate return in jdbc?
What is jndi lookup?
Is jdbctemplate thread safe?
How can we disable a constraint ?
How to rollback a JDBC transaction?
What is jdbc drivers in java?
What is jdbc driver?
How does jdbc driver work?
Explain how to make updates to the updatable resultsets.
Give an example for execution of sql statement.
Explain the locking system in jdbc & its types?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?