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...

What are the various Isolation levels?

Answer Posted / aaa

Isolation is a property that enables an operation to be
hidden, until its completion, from all the other similar
operations. This property is one of the Acid properties on
the Data Base Management System. However, isolation is the
most relaxed acid property. The management system has to
apply a lock of a limit to which the operation can be
accessed. These limits could be up to various levels. These
levels are called the isolation levels. There are 4 main
types of isolation levels: Serializable: at this level, all
the transactions occur in an isolated fashion; Repeatable
Read: when data cannot be changed; Read Committed: when
data can be modified by some other transaction; Read
Uncommitted: at this level, the changes made by one
transaction can be seen by another transaction. There are a
lot of weaknesses in the way each of the levels have been
defined.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If any stored procedure is encrypted, then can we see its definition in activity monitor?

991


What is federation member?

116


What is the meaning of sql server?

986


can you instantiate a com object by using t-sql? : Sql server database administration

1002


Explain the steps to create and execute a user-defined function in the sql server?

970


Different types of keys in SQL?

1099


How can we call UDF(User Define Function) using C# code in ASP.net ?

6886


What is the difference between web edition and business edition?

111


How you can get a list of all the table constraints in a database?

956


Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075


What are the different types of data sources in ssrs?

196


How to call a function from a stored procedure in SQL Server ?

1029


Does partitioning improve performance sql server?

983


How do you create an execution plan?

948


How network traffic be reduced by using the stored procedure?

1118