Which are the different IsolationLevels ?

Answers were Sorted based on User's Feedback



Which are the different IsolationLevels ?..

Answer / 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

Which are the different IsolationLevels ?..

Answer / ravindarjobs

have a look at this link


http://msdn2.microsoft.com/en-us/library/aa213034.aspx

Is This Answer Correct ?    0 Yes 0 No

Which are the different IsolationLevels ?..

Answer / 1647264

Following are the various IsolationLevels:

� 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 ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What is the difference between oledb sql server and oledbdotnet provider?

0 Answers  


If a table contains 20000 records. In a page at each time 100 records to be displayed.

0 Answers  


What is ado recordset?

0 Answers  


What is a dataview?

0 Answers  


Can we load multiple tables in a dataset?

0 Answers  






What are all components of ADO.Net data provider?

0 Answers  


How is it possible to get 2 tables of data at a time by using data reader?

0 Answers  


What is microsoft ado.net?

0 Answers  


What are basic methods of dataadapter?

0 Answers  


Can you edit data in the Repeater control?

9 Answers  


What are the usages of the command object in ado.net?

0 Answers  


Define table relations?

0 Answers  


Categories