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 are joins in sql and what are the different types of joins?
What are the system database in sql server 2005?
How to create a view on an existing table in ms sql server?
How to backup SQL Server Reporting Services ?
what is a self join? : Sql server database administration
What are the different index configurations a table can have?
Write down the syntax and an example for create, rename and delete index?
How do indexes help, types?
What is the difference RDBMS and Graph Database?
What is an example of a primary key?
What is a database table?
What is a view in sql?
Can sql servers linked to other servers?
Can a table have 2 foreign keys?
Tell me what is use of except clause? How it differs from not in clause?
