FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Distributed Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Performance
B) Fragmentation
C) Location
D) Local mapping

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

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

One of the advantages of a DDBMS is processor ____________________.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

A fully distributed database management system must perform all of the functions of a centralized DBMS. What are these functions?

What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

____ transparency ensures that the system will continue to operate in the event of a node failure.

A distributed ____ allows a transaction to reference several different remote database processing sites.

____ transparency allows a distributed database to be treated as a single logical database.

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

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

____ transparency allows a transaction to update data at several network sites.

One of the advantages of a DDBMS is improved communication.

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

____ is a disadvantage of a DDBMS.

____ is a disadvantage of a DDBMS.

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

____ distributed database systems integrate only one type of centralized DBMS over a network.

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

If a DDBMS exhibits ____________________ transparency, the user does not need to know that the data are partitioned-meaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.

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