Explain ACID rule of thumb for transactions.

Answer Posted / vishalakshi patil

Atomicity- Each transaction is said to be atomic if when
one part of the transaction fails, the entire transaction
fails and database state is left unchanged.

Consistency-transaction will take the database from one
consistent state to another consistent state.

Isolation-Isolation refers to the requirement that other
operations cannot access or see data that has been modified
during a transaction that has not yet completed

Durability-Durability is the DBMS's guarantee that once the
user has been notified of a transaction's success, the
transaction will not be lost.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is char * null terminated?

608


What is the difference between virtual method and abstract method?

621


What is singleordefault?

599


What is parallel foreach c#?

591


How to implement delegates in c#.net

639






Why does my windows application pop up a console window every time I run it?

606


Why do you need boxing in c#?

576


Why do we need generics in c#?

588


What are the benefits of using the aggregate method in linq?

580


What is the purpose of namespace?

537


Give an example of a directcast.

592


Can we declare private class in c#?

555


What is the meaning of 0 in c#?

629


What is global namespace in c#?

587


Why do we need singleton pattern in c#?

580