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
Ten grams of dietary fat contains how many food calories?
What kind of bond does hcl have?
How do you prepare a solution of 1 m hcl?
What Network traffic is generated if one call connect on a socket of type SOCK – DGRAM?
What is meant by transparency in client server environment?
Why do some medications contain hcl?
What are general middleware in client server environment?
What is the concentration, in parts per billion, of a solution that contains 1 microgram of solute per liter?
What is the direction of the dipole moment expected for carbon tetrachloride?
How reactive is trimethylindium towards oxygen and water?
Which of the instruments would typically be used to measure the smallest quantities of mass:
What is the term for the ph at which an amino acid or protein becomes electrically neutral?
Which are not carbonate minerals?
What are the differences between organic and inorganic chemistry?
Which is the correct name for n2o3?