What is ACID property?

Answer Posted / imran siddiqui

A transaction is an atomic unit of work that must be
completed in its entirety.The transaction succeeds if it
committed and fails if it is aborted.

Database theory has a more rigorous definition of a
transaction and states that a transaction has four
fundamental properties, known as ACID properties:

A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.

C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.

I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.

D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid property in client server environment?

560


What is the chemical formula for dichromate?

590


What are the different client/server processing styles?

2448


The disruption of the three-dimensional shape of a protein by factors such as heat, acids, bases, and organic solvents, is called what?

602


What is the chemical formula for epsom salts?

616






What is a tripod? How it is used?

593


What is meant by 2-tier architecture in client server environment?

579


Never found uncombined on earth, what element occurs abundantly in limestone, gypsum and fluorite?

558


What is the equation for photosynthesis?

574


can you show you the organic structure of cetearyl alcohol and tell me what organic family it is?

646


Think about the hardware limit on system calls. How can a system designer add additional system call without changing the hardware?

2275


What is a web server in client server environment?

542


What is the ph of an alkyl halide?

563


What is the ph of a solution with a hydronium ion concentration of 1 x 10-8 moles/dm3?

532


To a server method, the client wants to send a value 20, with this value exceeds to 20 a message should be sent to the client . What will you do for achieving this?

588