Purchase Solution

Multi-User Databases Management

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

Multi-User Databases Management is featured.

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 ...

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.