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
Element a is a nonmetal with an electronegativity value of 3.0 and element b is a nonmetal with an electronegativity value of 2.5. What kind of bonding will occur between these two elements?
What is meant by Asymmetrical protocols?
In RMI ,server object is first loaded into memory and then the stub reference is sent to the client. true or false?
Knowing that iron has an atomic number of 26, how many protons and how many electrons does fe+2 have?
Which are not carbonate minerals?
What are the different client/server processing styles?
To the nearest whole number, convert 0.300 atmosphere into millimeters of mercury, or torr:
What is structured query langauge (sql)?
What is the use of glacial acetic acid?
Tell me what are the three types of sql database server architecture?
Why do some medications contain hcl?
How are dipole attractions london dispersion forces and hydrogen bonding similar?
What is the function of a monosaccharide?
What are the isomers of heptane?
What are substrates?