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

Essay

Review LaterAdd Note

Review Later

Describe performance transparency and heterogeneity transparency.

Correct Answer

verified

Performance transparency allows the syst...

View Answer

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Transaction
B) Distribution
C) Failure
D) Performance

E) A) and C)
F) All of the above

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

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

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

Distribution transparency is supported by a distributed data dictionary.

A DDBMS is subject to which restriction?

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

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

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

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

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