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
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Explain table valued parameters in sql server? Why tvp used?
How except clause is differs from not in clause?
How to use go command in "sqlcmd"?
Do you know what is openxml in sql server?
What is autocommit mode in sql server?
What is the difference between seek predicate and predicate?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How many joins in sql server?
What is a join in sql?
What are various limitations of the views?
What happens if you delete a table that is used by a view?
Tell me what is log shipping?
What do you understand by a view? What does the with check option clause for a view do?
Why it is recommended to avoid referencing a floating point column in the where clause?
