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