Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the New in SQL server 2008?
Explain sub-query?
What do you understand by recursive stored procedures?
How to retrieve field values using mssql_result()?
What is rank function?
What are the aggregate and scalar functions?
What is a fill factor?
How to edit table in sql server 2017?
What is the usage of the sign function?
What do you mean by a Composite primary key?
Tell me something about security and sql azure?
What is buffer cash in sql server?
What is difference between drop truncate and delete?
When should you use an instead of trigger?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
