Explore BrainMass
Share

Explore BrainMass

    Multi-User Databases Management

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 9, 2019, 6:16 pm ad1c9bdddf
    https://brainmass.com/computer-science/operating-systems/multi-user-databases-management-83382

    Solution Preview

    1. Explain the difference between an exclusive lock and a shared lock.

    An exclusive lock prohibits other users from reading the locked resource; a shared lock allows other users to read the locked resource, but they cannot update it.

    2. Explain the difference between optimistic locking and pessimistic locking.

    Optimistic locking assumes no transaction conflict will occur and deals with the consequences if it does. Pessimistic locking ...

    Solution Summary

    Multi-User Databases Management is featured.

    $2.19