Work through the following materials this week, making sure that you can do the given activities.

1. Sections 20.1-20.4.1 & 20.6 — Explain the following.

   1. interleaving vs. parallelism

   2. the lost update, dirty read and incorrect summary problems

   3. transactions, including commits and rollbacks

   4. the ACID properties

   5. schedule

2. Chapter 21 introduction and Section 21.1 — Explain the following.

   1. lock

   2. two-phase locking

3. Review Oracle’s Overview of Transaction Processing in PL/SQL (only; you can skip the other sections on this page) — Compare and contrast the following.

   1. SAVEPOINT, COMMIT vs ROLLBACK [TO]

   2. LOCK TABLE vs. FOR UPDATE