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
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is federation member?
What is the meaning of sql server?
can you instantiate a com object by using t-sql? : Sql server database administration
Explain the steps to create and execute a user-defined function in the sql server?
Different types of keys in SQL?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is the difference between web edition and business edition?
How you can get a list of all the table constraints in a database?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are the different types of data sources in ssrs?
How to call a function from a stored procedure in SQL Server ?
Does partitioning improve performance sql server?
How do you create an execution plan?
How network traffic be reduced by using the stored procedure?