Database Management System - Old Questions

5. (a) Discuss the ACID properties of a database transaction with suitable example.[5]

    (b) Indicate how the recovery scheme works in a single user environment if the system fails

        i)After the transaction starts and before the read.

        ii)After the read and before the write.

        iii)After the write and before the commit.

        iv)After the commit and before al database entries are flushed onto disk.[5]