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
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is usually the first word in a sql query?
What is index in an assignment?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How sql server enhances scalability of the database system?
Write a sql query to get zero records from a table having n number of records?
What is DCL?
What is snapshot replication?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What happens if null values are involved in boolean operations?
What is the difference between coalesce() & isnull()?
Why do you need a sql server?
How to download microsoft sql server 2005 express edition?
Can I use sql azure as a backup with log shipping or database mirroring?
What is the difference between primary key and unique constraints?
