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

is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) remote request
B) remote transaction
C) distributed request
D) distributed transaction

E) B) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

Distributed processing does not require:

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .

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

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

Which of the following is an advantage associated with a distributed database management system (DDBMS) ?

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

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

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

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

A centralized database management is subject to a problem such as .

A distributed database management system (DDBMS) must be communications-media-dependent.

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

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

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

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

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 allows the integration of several different local database management systems (DBMS) under a common, or global, schema.