Week7 - Transaction Concepts, ACID Properties / Analyze

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Look the three diagrams and identify the ACID properties.

Question 1
Diagram 1

(c) Atomicity

Question 2
Diagram 2

(a) Consistency

Question 3
Diagram 3

(b) Isolation

2. Look at the following table and identify what each ACID property will do.

A

(a) All or nothing.

C

(b) Each transaction leaves the database consistent; otherwise rolled back.

I

(c) Each transaction is executed as if it was the only one running.

D

(d) A committed transaction cannot be aborted and its effects cannot be undone.

3. Lable the state diagram of transaction.

State 1

(b) Active

State 2

(a) Partially committed

State 3

(d) committed

State 4

(c) failed

State 5

(e) aborted