DISTRIBUTED DATABASES QUIZ

True

False

Software complexity

Software cost

Slow Response

Modular growth

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

All of these

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

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

Each site must have the same storage capacity.

Each transaction may proceed without coordination across the network.

Reduced network traffic

If the database fails at one site, a copy can be located at another site.

False

True

False

True

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 not distributed across all nodes.

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

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

True

False

True

False

True

False