Questions:
Multi-User Databases Management
1. Explain the difference between an exclusive lock and a shared lock.
2. Explain the difference between optimistic locking and pessimistic locking.
3. What is deadlock? How can it be avoided? How can it be resolved once it occurs?
4. What are the major functions of the database administrator?
5. Explain what we mean by an ACID transaction.