Question

Match the following terms with a short description of that term: Consistency, Atomicity, Isolation, Durability, Serializability.a. The data used by one transaction can not be used by another transaction until the first one has completed. b. The schedule for execution in a multiuser environment insures consistent results. c. A transaction takes the database from one consistent state to another. d. Once a transaction is done it can not be lost or undone. e. All statements within a transaction must be successfully completed or completely aborted.

Answer 1

Atomicity: All statements within a transaction must be successfully completed or completely aborted.

Consistency: A transaction takes the database from one consistent state to another.

Isolation: The data used by one transaction can not be used by another transaction until the first one has completed

Durability: Once a transaction is done it can not be lost or undone.

Serializability: The schedule for execution in a multiuser environment insures consistent results