C# (Sharp) Programming Language Question:

Download Job Interview Questions and Answers PDF

Explain ACID rule of thumb for transactions in C#.

C# (Sharp) Programming Language Interview Question
C# (Sharp) Programming Language Interview Question

Answer:

A transaction must be:
1. Atomic - it is one unit of work and does not dependent on previous and following transactions.
2. Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
3. Isolated - no transaction sees the intermediate results of the current transaction).
4. Durable - the values persist if the data had been committed even if the system crashes right after.

Download C# (Sharp) Programming Language Interview Questions And Answers PDF

Previous QuestionNext Question
What are three test cases you should go through in unit testing?Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?