Share
Explore BrainMass

DB2, SQL Server, MySQL, Oracle, or Sybase

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.

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

Solution Summary

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

$2.19