Question1. Describe the difference between an exclusive lock and a shared lock.
Question2. Describe the difference between optimistic locking and pessimistic locking.
Question3. Define deadlock and how can it be avoided? How can it be resolved once it occurs?
Question4. What are the major functions of the database administrator?
Question5. Describe what we mean by an ACID transaction.