Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

concurrency

Question 3

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

Accepted Answer

A) True 
 B)False  False

Question 4

A user-friendly ____________________ is one advantage of a DDBMS.

Accepted Answer

The answer of A user-friendly ____________________ is one advantage of...

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

A remote transaction,composed of several requests,may access data at multiple sites.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Current DDBMSs are subject to some problems,such as the complexity of management and control.

Accepted Answer

A) True 
 B)False

Question 9

A distributed database system requires functional characteristics that can be grouped and described as transparency features.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   sections
B)   fragments
C)   partitions
D)   parts

Question 11

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

Accepted Answer

The answer of What is transaction transparency? What are some...

Question 12

The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.

Accepted Answer

The answer of The ____________________ fragment condition indicates that each...

Question 13

In a DDBMS,____________________ occurs to determine the data location of local and remote fragments.

Accepted Answer

The answer of In a DDBMS,____________________ occurs to determine the...

Question 14

Describe performance transparency and heterogeneity transparency.

Accepted Answer

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

Question 15

____ is a disadvantage of a DDBMS.

Accepted Answer

A)   Processor independence
B)   User-friendly interface
C)   Security
D)   Faster data access

Question 16

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

Accepted Answer

The answer of The database description,known as the distributed ____________________...

Question 17

____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.

Accepted Answer

A)   Static
B)   Dynamic
C)   Automatic
D)   Commit

Question 18

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

Accepted Answer

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

Question 19

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

Accepted Answer

The answer of One of the advantages of a DDBMS...

Question 20

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

Accepted Answer

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

Exam 12: Distributed Database Management Systems

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

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

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

A user-friendly ____________________ is one advantage of a DDBMS.

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.

A remote transaction,composed of several requests,may access data at multiple sites.

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

Current DDBMSs are subject to some problems,such as the complexity of management and control.

A distributed database system requires functional characteristics that can be grouped and described as transparency features.

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

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

The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.

In a DDBMS,____________________ occurs to determine the data location of local and remote fragments.

Describe performance transparency and heterogeneity transparency.

____ is a disadvantage of a DDBMS.

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

____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.

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

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

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