Question 1

One of the advantages of a DDBMS is processor ____________________.

Accepted Answer

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

Question 2

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 3

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

Accepted Answer

A)  Homogeneous 
B)  Heterogeneous 
C)  Fully heterogeneous 
D)  Combination 
A)  Homogeneous 
B)  Heterogeneous 
C)  Fully heterogeneous 
D)  Combination

Question 4

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

Accepted Answer

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

Question 5

____ is a disadvantage of a DDBMS.

Accepted Answer

A)  Data is located near the "greatest demand" site 
B)  Growth facilitation 
C)  Danger of a single-point failure 
D)  Lack of standards 
A)  Data is located near the "greatest demand" site 
B)  Growth facilitation 
C)  Danger of a single-point failure 
D)  Lack of standards

Question 6

A DDBMS must be communications-media-dependent.

Accepted Answer

A) True 
 B)False

Question 7

____ 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 
A)  Transaction 
B)  Distribution 
C)  Failure 
D)  Performance

Question 8

The ____ rule requires that all copies of data fragments be identical.

Accepted Answer

A)  shared fragment 
B)  mutual consistency 
C)  horizontal fragmentation 
D)  replication 
A)  shared fragment 
B)  mutual consistency 
C)  horizontal fragmentation 
D)  replication

Question 9

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

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

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

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

Transaction transparency is a DDBMS prop

Question 13

Typically,the _________________________ scenario requires a network file server running conventional applications that are accessed through a network.

Accepted Answer

multiple-site proces

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

The answer of If a DDBMS exhibits ____________________ transparency,the user...

Question 16

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 17

Describe performance transparency and heterogeneity transparency.

Accepted Answer

Performance transparency allows the syst

Question 18

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 19

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

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

Accepted Answer

A)  transaction 
B)  network 
C)  data 
D)  management 
A)  transaction 
B)  network 
C)  data 
D)  management

One of the advantages of a DDBMS is processor ____________________.

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

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

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

____ is a disadvantage of a DDBMS.

A DDBMS must be communications-media-dependent.

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

The ____ rule requires that all copies of data fragments be identical.

____ are an advantage of a DDBMS.

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

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

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

Typically,the _________________________ scenario requires a network file server running conventional applications that are accessed through a network.

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

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.

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

Describe performance transparency and heterogeneity transparency.

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

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

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

One of the advantages of a DDBMS is processor ____________________.

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

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

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

____ is a disadvantage of a DDBMS.

A DDBMS must be communications-media-dependent.

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

The ____ rule requires that all copies of data fragments be identical.

____ are an advantage of a DDBMS.

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

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

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

Typically,the _________________________ scenario requires a network file server running conventional applications that are accessed through a network.

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

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.

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

Describe performance transparency and heterogeneity transparency.

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

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

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters