Question 1

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

Accepted Answer

A)  mixed 
B)  replicated 
C)  centralized 
D)  partitioned

Question 2

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

Accepted Answer

A)  Transaction 
B)  Distribution 
C)  Failure 
D)  Performance

Question 3

Distribution transparency is supported by a distributed data dictionary.

Accepted Answer

A) True 
 B)False

Question 4

Describe performance transparency and heterogeneity transparency.

Accepted Answer

The answer of Describe performance transparency and heterogeneity transparency....

Question 5

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

Accepted Answer

The answer of The distributed database system must be _____...

Question 6

Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A DDBMS is subject to which restriction?

Accepted Answer

A)  Multiple instances of the same database should be integrated over a network. 
B)  All database processing must be done at a single site. 
C)  Rapid ad hoc data access is not possible. 
D)  Remote data access is provided on a read-only basis.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The answer of The _____ scenario is typical of most...

Question 13

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

Accepted Answer

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

Question 14

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.

Accepted Answer

The answer of In a distributed database management system (DDBMS),...

Exam 12: Distributed Database Management Systems

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

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

Distribution transparency is supported by a distributed data dictionary.

Describe performance transparency and heterogeneity transparency.

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

Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control.

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

A DDBMS is subject to which restriction?

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

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

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

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

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

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.