Question 1

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 2

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

Accepted Answer

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

Question 3

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

_____ 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 6

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

Accepted Answer

communicat

Question 7

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

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 8

A distributed _____ can reference several different local or remote data processing sites.

Accepted Answer

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

Question 9

The _____ protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

Accepted Answer

DO-UNDO-REDO
DO UNDO

Question 10

The transaction processor (TP) is the software component found in each computer that requests data.

Accepted Answer

A) True 
 B)False

Question 11

Theweb is the repository for distributed data.

Accepted Answer

A) True 
 B)False

Question 12

Explain the three types of operations defined by the DO-UNDO-REDO protocol.

Accepted Answer

DO performs the operation and records th

Question 13

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Accepted Answer

A) True 
 B)False

Question 14

_____ transparency allows the system to operate 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

Question 15

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 16

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 17

A database management system (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 18

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

Accepted Answer

Transaction transparency is a DDBMS prop

Question 19

The _____ forces the log entry to be written to permanent storage before the actual operation takes place.

Accepted Answer

write-ahea

Question 20

A fully distributed database management system (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

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

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

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

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

_____ 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 basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

A distributed _____ can reference several different local or remote data processing sites.

The _____ protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

The transaction processor (TP) is the software component found in each computer that requests data.

Theweb is the repository for distributed data.

Explain the three types of operations defined by the DO-UNDO-REDO protocol.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

_____ transparency allows the system to operate as if it were a centralized database management system.

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

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

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

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

The _____ forces the log entry to be written to permanent storage before the actual operation takes place.

A fully distributed database management system (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.

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

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

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

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

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

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

_____ 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 basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

A distributed _____ can reference several different local or remote data processing sites.

The _____ protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

The transaction processor (TP) is the software component found in each computer that requests data.

Theweb is the repository for distributed data.

Explain the three types of operations defined by the DO-UNDO-REDO protocol.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

_____ transparency allows the system to operate as if it were a centralized database management system.

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

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

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

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

The _____ forces the log entry to be written to permanent storage before the actual operation takes place.

A fully distributed database management system (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.

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

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters