Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dirty, commited ,phantom,repeatable
reads?
- 3 Answers
- 27194 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 the difference between setmaxrows(int) and setfetchsize(int)?
Which is better jpa or jdbc?
What is meant by dao?
What do you mean by metadata and why we are using it?
How to insert an image or raw data into database?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
How to use JDBC API to call Stored Procedures?
What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?
What is odbc and jdbc?
Give steps to connect to the db using jdbc?
Explain Basic Steps in Writing a Java Program Using Jdbc?
What is jdbc odbc connection?
What is sqlwarning and discuss the procedure of retrieving warnings?
Where can I find info, frameworks and example source for writing a JDBC driver?
