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 1

True/False

Review LaterAdd Note

Review Later

One of the advantages of a DDBMS is security.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

____ distributed database systems integrate different types of centralized DBMSs over a network.

A) Homogeneous
B) Heterogeneous
C) Fully homogeneous
D) Combination

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

____ fragmentation allows you to break a single object into two or more segments or fragments.

The World Wide Web (the Web)is the repository for distributed data.

A fully distributed 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.

In a DDBMS,query ____________________ is used to find the best access strategy.

The _________________________ scenario is typical of most mainframe and midrange server computer DBMSs.

Explain heterogeneous distributed database systems.

One of the advantages of a DDBMS is improved communication.

Both distributed processing and distributed databases require a network to connect all components.

____ 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 ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

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

In order to manage distributed data,copies or parts of the database processing functions must be distributed to all data storage sites.

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

The objective of ____ optimization is to minimize the total cost associated with the execution of a request.

A DBMS must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

Under the ____ scenario,multiple processes run on different computers sharing a single data repository.

In a DDBMS,____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.

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