What is Isolation?
Submitted by: AdministratorA transaction is a unit of isolation ? allowing concurrent transactions to behave as though each were the only transaction running in the system.
Isolation requires that each transaction appear to be the only transaction manipulating the data store, even though other transactions may be running at the same time. A transaction should never see the intermediate stages of another transaction.
Transactions attain the highest level of isolation when they are serializable. At this level, the results obtained from a set of concurrent transactions are identical to the results obtained by running each transaction serially.
Because a high degree of isolation can limit the number of concurrent transactions, some applications reduce the isolation level in exchange for better throughput.
Submitted by: Administrator
Isolation requires that each transaction appear to be the only transaction manipulating the data store, even though other transactions may be running at the same time. A transaction should never see the intermediate stages of another transaction.
Transactions attain the highest level of isolation when they are serializable. At this level, the results obtained from a set of concurrent transactions are identical to the results obtained by running each transaction serially.
Because a high degree of isolation can limit the number of concurrent transactions, some applications reduce the isolation level in exchange for better throughput.
Submitted by: Administrator
Read Online ADO.NET Job Interview Questions And Answers
Top ADO.NET Questions
☺ | Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET? |
☺ | Difference between SqlCommand and SqlCommandBuilder? |
☺ | Can dataReader hold data from multiple tables? |
☺ | What provider ADO.net use by default? |
☺ | What is different between SqlCommand object and Command Behavior Object? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |