Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 25933 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 is jdbc driver?
What is the advantage of namedparameterjdbctemplate?
RowSetInternal caller and returns void. What can I do in the readData method?
What does the jdbc databasemetadata interface?
Discuss the procedure of retrieving warnings?
Under what circumstances, that all four drivers are used?
What is jdbc and its types?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What is jdbc architecture in java?
Where is jdbc url mysql?
Is jdbctemplate thread safe?
How many types of jdbc drivers are available?
What is jdbc and explain jdbc architecture?
How can we disable a constraint ?
What is an encrypted internet connection?
