Question 1

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 2

transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

Accepted Answer

A)  remote request 
B)  remote transaction 
C)  distributed request 
D)  distributed transaction 
A)  remote request 
B)  remote transaction 
C)  distributed request 
D)  distributed transaction

Question 5

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .

Accepted Answer

communicat

Question 6

A centralized database management is subject to a problem such as .

Accepted Answer

A)  a growing number of remote locations 
B)  maintaining and operating small database systems 
C)  dependence on multiple sites 
D)  organizational flexibility of the database 
A)  a growing number of remote locations 
B)  maintaining and operating small database systems 
C)  dependence on multiple sites 
D)  organizational flexibility of the database

Question 7

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 8

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 9

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 10

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

Accepted Answer

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

Question 11

_____ distributed database management system (DDBMS) integrate multiple instances of the same 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 12

A database management system needs to prepare the data for presentation to the end user or to an application program.

Accepted Answer

A)  security 
B)  concurrency control 
C)  formatting 
D)  I/O interface 
A)  security 
B)  concurrency control 
C)  formatting 
D)  I/O interface

Question 13

In theory, a(n) can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

Accepted Answer

A)  transaction processor 
B)  application processor 
C)  transaction manager 
D)  data processor 
A)  transaction processor 
B)  application processor 
C)  transaction manager 
D)  data processor

Question 14

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

Accepted Answer

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

Question 15

A distributed database management system (DDBMS) must be communications-media-dependent.

Accepted Answer

A) True 
 B)False

Question 16

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 
A)  Horizontal 
B)  Vertical 
C)  Data 
D)  Request

Question 17

Distributed processing does not require:

Accepted Answer

A)  database processing functions to be distributed to all data storage sites. 
B)  an existing distributed database. 
C)  a network of interconnected components. 
D)  multiple sites to share processing chores. 
A)  database processing functions to be distributed to all data storage sites. 
B)  an existing distributed database. 
C)  a network of interconnected components. 
D)  multiple sites to share processing chores.

Question 18

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 19

In a distributed database management system (DDBMS), query is used to find the best access strategy.

Accepted Answer

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

Question 20

Which of the following is an advantage associated with a distributed database management system (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

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

transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.

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

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .

A centralized database management is subject to a problem such as .

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 objective of optimization is to minimize the total cost associated with the execution of a request.

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

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

_____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.

A database management system needs to prepare the data for presentation to the end user or to an application program.

In theory, a(n) can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

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

A distributed database management system (DDBMS) must be communications-media-dependent.

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

Distributed processing does not require:

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

In a distributed database management system (DDBMS), query is used to find the best access strategy.

Which of the following is an advantage associated with a distributed database management system (DDBMS)?

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

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

transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.

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

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .

A centralized database management is subject to a problem such as .

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 objective of optimization is to minimize the total cost associated with the execution of a request.

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

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

_____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.

A database management system needs to prepare the data for presentation to the end user or to an application program.

In theory, a(n) can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

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

A distributed database management system (DDBMS) must be communications-media-dependent.

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

Distributed processing does not require:

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

In a distributed database management system (DDBMS), query is used to find the best access strategy.

Which of the following is an advantage associated with a distributed database management system (DDBMS)?

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