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 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The rule requires that all copies of data fragments be identical.

A) shared fragment
B) mutual consistency
C) horizontal fragmentation
D) replication

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

Distributed processing does not require:

_____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.

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.

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

A distributed can reference several different local or remote data processing sites.

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

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

Distribution transparency is supported by a distributed data dictionary.

The database description,known as the distributed schema,is the common database schema used by local transaction processors (TPs)to translate user requests into subqueries that will be processed by different data processors (DPs).

A request lets a single SQL statement reference data located at several different local or remote DP sites.

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

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

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

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

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

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