DISTRIBUTED DATABASES QUIZ

The same DBMS is at each node and a central DBMS coordinates database access.

A different DBMS is at each node and each DBMS works independently.

The same DBMS is at each node and each DBMS works independently.

A different DBMS is at each node and a central DBMS coordinates database access.

True

False

All of these

Users to treat the data as if it is at one location

Managers to treat the data as if it is at one location

Programmers to treat the data as if it is at one location

The application's data can be somewhat out-of-date.

All of these

When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.

When using many nodes with different operating systems and DBMSs and database designs.

Data Replication

Vertical Partitioning

Horizontal Partitioning

Horizontal and Vertical Partitioning

The same DBMS is used at each location and data are not distributed across all nodes.

A different DBMS is used at each location and data are distributed across all nodes.

The same DBMS is used at each location and data are distributed across all nodes.

A different DBMS is used at each location and data are not distributed across all nodes.

Partially or totally replicated across sites

All of these

Partitioned into segments at different sites

Totally centralized at one location and accessed by many sites

A single logical database that is spread to multiple locations and is interconnected by a network

A loose collection of file that is spread to multiple locations and is interconnected by a network

A single logical database that is limited to one location.

A loose collection of file that is limited to one location.

False

True

True

False