MIS 4330 CHAPTER 12 QUIZ

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

The Internet is the repository for distributed data

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

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

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

Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

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

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

Distribution transparency is supported by a distributed data dictionary.

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

A distributed database is composed of several parts known as database _____.

Distributed processing does not require

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

A DDBMS is subject to which of the following restrictions?

_____ transparency allows a physically dispersed database to be managed as though it were centralized.

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

_____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

_____ 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.

The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

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

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