Purchase Solution

DB2, SQL Server, MySQL, Oracle, or Sybase

Not what you're looking for?

Ask Custom Question

Use the Internet or computer magazines to investigate one of the following DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Then prepare a report that explains how the DBMS handles tow of the following distributed database functions: deadlock, fragmentation, replication, the data dictionary or log, and distributed queries.

Purchase this Solution

Solution Summary

Assess one of the following DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase

Solution Preview

DB: Oracle

1. Fragmentation: Please see

http://www.embarcadero.com/resources/tech_papers/managingspace.pdf

2. Replication, please see the attached documents. and also:
http://www.nyoug.org/200212baumgartel.pdf

3. Deadlock detection in Oracle: see the attached document.

4. Distributed queries:

Distributed Queries

A ...

Purchase this Solution


Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Networking Questions

This quiz consists of some basic networking questions.

Excel Introductory Quiz

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

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.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.