How many isolation levels are present and what are they?

 Posted by Kmandapalli on 2/25/2014 | Category: WCF Interview questions | Views: 2334 | Points: 40

1. READ UNCOMMITTED: - An uncommitted transaction can be read. This transaction can be rolled back later.
2. READ COMMITTED :- Will not read data of a transaction that has not been committed yet
3. REPEATABLE READ: - Locks placed on all data and another transaction cannot read.
4. SERIALIZABLE:- Does not allow other transactions to insert or update data until the transaction is complete.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response