Explore BrainMass
Share

DB2, SQL Server, MySQL, Oracle, or Sybase

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

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.

© BrainMass Inc. brainmass.com September 18, 2018, 11:22 pm ad1c9bdddf - https://brainmass.com/computer-science/data-clustering/db2-sql-server-mysql-oracle-or-sybase-45774

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