Question 1

____ transparency allows the system to perform as if it were a centralized database management system.

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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  True

Question 4

____________________ management ensures that data move from one consistent state to another, including synchronization of local and remote transactions.

Accepted Answer

The answer of ____________________ management ensures that data move from...

Question 5

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

Accepted Answer

A)  multiple-site processing, single-site data 
B)  single-site processing, multiple-site data 
C)  single-site processing, single-site data 
D)  multiple-site processing, multiple-site data 
A)  multiple-site processing, single-site data 
B)  single-site processing, multiple-site data 
C)  single-site processing, single-site data 
D)  multiple-site processing, multiple-site data

Question 6

____ are an advantage of a DDBMS.

Accepted Answer

A)  Reduced operating costs 
B)  Simplicity of management and control 
C)  Decreased storage requirements 
D)  Decreased training costs 
A)  Reduced operating costs 
B)  Simplicity of management and control 
C)  Decreased storage requirements 
D)  Decreased training costs

Question 7

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

Accepted Answer

A)  fully heterogeneous 
B)  fully homogeneous 
C)  homogeneous 
D)  heterogeneous 
A)  fully heterogeneous 
B)  fully homogeneous 
C)  homogeneous 
D)  heterogeneous

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

____ 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.

Accepted Answer

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

Question 10

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...

Question 11

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

Accepted Answer

The answer of In a DDBMS, ____________________ control is used...

Question 12

One of the advantages of a DDBMS is growth facilitation.

Accepted Answer

A) True 
 B)False

Question 13

Under the ____ scenario, multiple processes run on different computers sharing a single data repository.

Accepted Answer

A)  single-site processing, single-site data 
B)  multiple-site processing, single-site data 
C)  single-site processing, multiple-site data 
D)  multiple-site processing, multiple-site data 
A)  single-site processing, single-site data 
B)  multiple-site processing, single-site data 
C)  single-site processing, multiple-site data 
D)  multiple-site processing, multiple-site data

Question 14

Describe performance transparency and heterogeneity transparency.

Accepted Answer

Performance transparency allows the syst

Question 15

____ fragmentation refers to the division of a relation into subsets of tuples.

Accepted Answer

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

Question 16

The TP is the software component found in each computer that requests data.

Accepted Answer

A) True 
 B)False

Question 17

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

One of the advantages of a DDBMS is ____________________ operating cost.

Accepted Answer

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

____ transparency allows the system to perform as if it were a centralized database management system.

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

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.

____________________ management ensures that data move from one consistent state to another, including synchronization of local and remote transactions.

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

____ are an advantage of a DDBMS.

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

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

____ 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.

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

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 growth facilitation.

Under the ____ scenario, multiple processes run on different computers sharing a single data repository.

Describe performance transparency and heterogeneity transparency.

____ fragmentation refers to the division of a relation into subsets of tuples.

The TP is the software component found in each computer that requests data.

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

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

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

One of the advantages of a DDBMS is ____________________ operating cost.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 10: Distributed Databases

____ transparency allows the system to perform as if it were a centralized database management system.

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

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.

____________________ management ensures that data move from one consistent state to another, including synchronization of local and remote transactions.

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

____ are an advantage of a DDBMS.

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

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

____ 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.

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

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 growth facilitation.

Under the ____ scenario, multiple processes run on different computers sharing a single data repository.

Describe performance transparency and heterogeneity transparency.

____ fragmentation refers to the division of a relation into subsets of tuples.

The TP is the software component found in each computer that requests data.

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

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

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

One of the advantages of a DDBMS is ____________________ operating cost.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters