FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Distributed Database Management Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

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

A DDBMS is subject to which restriction?

Distribution transparency is supported by a distributed data dictionary.

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

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

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

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

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

Describe performance transparency and heterogeneity transparency.

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