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.

Question

Business

Turner Fuller

26 September, 20:14

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.

+2

Answers (1)

Know the Answer?

Kamari Juarez · 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