Exam 12: Distributed Database Management Systems

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.

A fully distributed database management system must perform all of the functions of a centralized DBMS.What are these functions?

A DDBMS must be communications-media-dependent.

What is a disadvantage of client/server applications?

A ____ query optimization algorithm is based on a set of user-defined rules to determine the best access strategy.

Typically,the __________________________________________________ scenario requires a network file server running conventional applications that are accessed through a network.

One of the advantages of a DDBMS is growth facilitation.

The DO-UNDO-REDO protocol defines three types of operations.What are they?

In a DDBMS,query ____________________ is used to find the best access strategy.

One of the advantages of a DDBMS is ____________________ operating cost.

The ____ rule requires that all copies of data fragments be identical.

Explain heterogeneous distributed database systems.

If a DDBMS exhibits ____________________ transparency,the user does not need to know that the data are partitioned-meaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.

____ transparency allows a distributed database to be treated as a single logical database.

____ fragmentation refers to the division of a relation into subsets of tuples.

____ is an advantage of a DDBMS.

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

A ____ contains the description of the entire database as seen by the database administrator.

____ is a disadvantage of a DDBMS.