INTERVIEW QUESTIONS MICROSOFT C# DETAILS

Question: Explain ACID rule of thumb for transactions.

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

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

ACID property that is Atomicity,Consistancy,Isolation,Durability

Automicity means the transaction must be executed whole or not.here partial execution of transaction must not done.Suppose one pearson withdrawn amount from one bank and deposited into another bank.this transaction must be perform whole or not at all

consistancy means the output must be consistance.here from the above example we can say that it maintain the consistant result in both the account

Isolation means the transactin must be in isolation that is in parallel.from the above example we can say that the deposite and the withdrawn taken place at the same time

Durability means transaction must be commited and servive permenatly
Thus its called the ACID property


Regards,
Nicku
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question