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
How to convert binary strings into integers in ms sql server?
How to delete a login name in ms sql server?
Explain what are the database objects? : SQL Server Architecture
Why main is user defined function?
How to insert and update data into a table with "insert" and "update" statements?
What structure can you implement for the database to speed up table reads?
What is a fan-out query in SQL Azure?
What does dml stand for?
How can I know what locks are running on which resource?
What is the difference between implicit and explicit transaction?
What do you understand by triggers?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is ms sql server reporting services?
Where sql server usernames and passwords are stored in a sql server?