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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Data
B) Horizontal
C) Vertical
D) Mixed

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

Data _____ describes the process of deciding where to locate data.

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.

After an update, the originating DP node sends the changes to the replica nodes to ensure that data is immediately updated, during _____replication.

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

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.

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.

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

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

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

During _____replication, after an update, the originating DP node sends "messages" to the replica nodes to notify them of the update.

A disadvantage of a distributed database management system (DDBMS) is:

A(n) _____ database stores each database fragment at a single site.

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

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

_____ management ensures that data move from one consistent state to another.

Explain the difference between homogeneous and heterogeneous distributed database management systems (DDBMS).

One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.

In a distributed database management system (DDBMS), query _____ is used to find the best access strategy.