Problem
1. What is deadlock? How can it be avoided? How can it be resolved when it occurs?
2. Explain the difference between optimistic and pessimistic locking.
3. Explain the benefits of marking transaction boundaries, declaring lock characteristics, and letting a DBMS place locks.
4. Explain the use of the SQL transaction control statements BEGIN TRANSACTION, COMMIT TRANSACTION, and ROLLBACK TRANSACTION.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.