Exam 12: Distributed Database Management Systems

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

_____ transparency allows data to be updated simultaneously at several network sites.

Distribution transparency is supported by a distributed data dictionary.

Describe performance transparency and heterogeneity transparency.

The distributed database system must be _____ of the computer system hardware.

Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control.

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

A DDBMS is subject to which restriction?

One of the advantages of a distributed database management system (DDBMS) is security.

A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.

Distributed data access was needed to support geographically dispersed business units.

The _____ scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.