PrepAway - Latest Free Exam Questions & Answers

This principle of data integrity is known as:

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:

PrepAway - Latest Free Exam Questions & Answers

A.
isolation.

B.
consistency.

C.
atomicity.

D.
durability.

Explanation:

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 databasebe maintained with each transaction. Isolation
ensures that each transaction is isolated from other transactions; 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.


Leave a Reply