In an online transaction processing system, data integrity
is maintained by ensuring that a transaction is either
completed in its entirety or not at all. This principle of
data integrity is known as:
A. isolation.
B. consistency.
C. atomicity.
D. durability.
- 2 Answers
- 8796 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Answer: C
The principle of atomicity requires that a transaction be
completed in its entirety or not at all. If an error or
interruption occurs, all changes made up to that point are
backed out. Consistency ensures that all integrity
conditions in the database be maintained with each
transaction. Isolation ensures that each transaction is
isolated from other transactions, and hence, each
transaction only accesses data that are part of a consistent
database state. Durability ensures that when a transaction
has been reported back to a user as complete the resultant
changes to the database will survive subsequent hardware or
software failures.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
