Question 1

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

Accepted Answer

A)  request 
B)  site 
C)  data location 
D)  transaction 
A)  request 
B)  site 
C)  data location 
D)  transaction

Question 2

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

Accepted Answer

single-site processi

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

1. Receive the request of an application

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

____ is a disadvantage of a DDBMS.

Accepted Answer

A)  Processor independence 
B)  The graphical user interface 
C)  Security 
D)  Data access that is too rapid 
A)  Processor independence 
B)  The graphical user interface 
C)  Security 
D)  Data access that is too rapid

Question 12

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

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

Accepted Answer

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

Question 14

One of the advantages of a DDBMS is processor ____________________.

Accepted Answer

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

Question 15

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 16

One of the advantages of a DDBMS is improved communication.

Accepted Answer

A) True 
 B)False

Question 17

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

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

Accepted Answer

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

Question 19

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

Accepted Answer

A)  data 
B)  remote 
C)  transaction 
D)  query 
A)  data 
B)  remote 
C)  transaction 
D)  query

Question 20

____ transparency 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 
A)  Performance 
B)  Fragmentation 
C)  Location 
D)  Local mapping

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

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

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

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

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

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

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

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 World Wide Web (the Web) is the repository for distributed data.

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

____ is a disadvantage of a DDBMS.

____ is a disadvantage of a DDBMS.

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

One of the advantages of a DDBMS is processor ____________________.

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

One of the advantages of a DDBMS is improved communication.

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

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

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

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

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

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

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

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

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

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

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

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

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 World Wide Web (the Web) is the repository for distributed data.

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

____ is a disadvantage of a DDBMS.

____ is a disadvantage of a DDBMS.

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

One of the advantages of a DDBMS is processor ____________________.

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

One of the advantages of a DDBMS is improved communication.

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

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

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

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

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