Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why we use while rs next ())?

901


Is possible to open a connection to a database with exclusive mode with JDBC?

921


What is jdbc connection string?

939


What does executeupdate return in jdbc?

921


What is jndi lookup?

888


Is jdbctemplate thread safe?

860


How can we disable a constraint ?

954


How to rollback a JDBC transaction?

1031


What is jdbc drivers in java?

869


What is jdbc driver?

857


How does jdbc driver work?

925


Explain how to make updates to the updatable resultsets.

865


Give an example for execution of sql statement.

962


Explain the locking system in jdbc & its types?

901


How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

941