All questions below pertain to material learned from the textbook (Chapter 10) and lectures. Please put all answers to the questions below in this document for grading. Please submit answers AND questions. Please note that most questions require unique examples that are not taken directly from the book. The reason for this is to provide you the opportunity to do some critical thinking with the material learned and to practice for similar exam essay questions.

1. (4 points) Explain the following statement: a transaction is a logical unit of work. Give a specific Oracle SQL code example of a complete transaction that makes sense and that is not in the book and explain it.
2. (4 points) List and discuss the five transaction properties. What are these properties used for? Explain each thoroughly and provide an example of each that is not in the book.

3. (4 points) What is a transaction log, and what is its function? Give a specific Oracle code example of a transaction log that is different from the one in the book and explain it.

4. (4 points) Explain/define the different levels of lock granularity? Explain each in your own words and provide examples (2).

5. (4 points) What is a deadlock, and how can it be avoided? Discuss several (3) for dealing with deadlocks using specific examples of each (2).