Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swapna
Serialized : Data read by a current transaction cannot be
changed by another transaction until the current
transaction finishes. No new data can be inserted that
would affect the current transaction. This is the safest
isolation level and is the default.
Repeatable : Read Data read by a current transaction
cannot be changed by another transaction until the current
transaction finishes. Any type of new data can be inserted
during a transaction.
Read Committed : A transaction cannot read data that is
being modified by another transaction that has not
committed. This is the default isolation level in
Microsoft? SQL Server.
Read Uncommitted : A transaction can read any data, even
if it is being modified by another transaction. This is the
least safe isolation level but allows the highest
concurrency.
Any Any isolation level is supported. This setting is
most commonly used by downstream components to avoid
conflicts. This setting is useful because any downstream
component must be configured with an isolation level that
is equal to or less than the isolation level of its
immediate upstream component.
Therefore, a downstream component that has its isolation
level configured as Any always uses the same isolation
level that its immediate upstream component uses. If the
root object in a transaction has its isolation level
configured to Any, its isolation level becomes Serialized.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How can I retrieve two tables of data at a time by using data reader?
What is an orm, and why would you use one instead of plain old ado.net?
What is ole2 format?
Difference between sqlcommand and sqlcommandbuilder?
What are the uses of Stored Procedure?
What are the major difference between classic ADO and ADO.NET?
What are the steps you will take to improve performance?
How would you connect to a database by using .NET?
How do you find the count of records in a dataset?
What is the full form of ado.net?
Do we use stored procedure in ADO.Net?
Define ado.net?
What is the difference between a datareader and a dataset?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the default timeout specified for "sqlcommand.commandtimeout" property?
