Question 1

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

Accepted Answer

A)  distributed UOW 
B)  join SQL statement 
C)  distributed request 
D)  data transfer command 
A)  distributed UOW 
B)  join SQL statement 
C)  distributed request 
D)  data transfer command

Question 2

The reliability of a decentralized distributed database system with independent partitions is poor.

Accepted Answer

A) True 
 B)False

Question 3

With an asynchronous distributed database, all data across the network is continuously kept up to date.

Accepted Answer

A) True 
 B)False

Question 4

A remote unit of work allows updates at the single remote computer.

Accepted Answer

A) True 
 B)False

Question 5

In a semijoin, all of the selected attributes from every selected row are transmitted to each site.

Accepted Answer

A) True 
 B)False

Question 6

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

Accepted Answer

A)  attribute linkup. 
B)  key data element transfer. 
C)  key data element join. 
D)  semijoin. 
A)  attribute linkup. 
B)  key data element transfer. 
C)  key data element join. 
D)  semijoin.

Question 7

Users of distributed database systems always need to know the location of the data.

Accepted Answer

A) True 
 B)False

Question 8

Applications that can tolerate out-of-date data are not the best candidates for data replication.

Accepted Answer

A) True 
 B)False

Question 9

The purpose of time-stamping is to allow transactions to be processed in parallel.

Accepted Answer

A) True 
 B)False

Question 10

Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following characterizes homogeneous environments?

Accepted Answer

A)  Contains simple pathways 
B)  Same DBMS used at all locations 
C)  Some users require only local access 
D)  Cross-linked systems easily communicate 
A)  Contains simple pathways 
B)  Same DBMS used at all locations 
C)  Some users require only local access 
D)  Cross-linked systems easily communicate

Question 12

Scalability is the ability to grow, reduce in size, and become more heterogeneous as the needs of the business change.

Accepted Answer

A) True 
 B)False

Question 13

In a homogeneous environment, the same DBMS is used at each location.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true of data replication?

Accepted Answer

A)  Reduced storage requirements 
B)  Slower response 
C)  Node decoupling 
D)  Requires Oracle 
A)  Reduced storage requirements 
B)  Slower response 
C)  Node decoupling 
D)  Requires Oracle

Question 15

The step in which a distributed database decides the order in which to execute the distributed query is called:

Accepted Answer

A)  decomposition. 
B)  localization. 
C)  step optimization. 
D)  global optimization. 
A)  decomposition. 
B)  localization. 
C)  step optimization. 
D)  global optimization.

Question 16

A distributed unit of work does not support location transparency.

Accepted Answer

A) True 
 B)False

Question 17

A distributed request allows a single SQL statement to refer to tables in more than one remote DBMS.

Accepted Answer

A) True 
 B)False

Question 18

Replicated databases usually result in tightly coupled nodes.

Accepted Answer

A) True 
 B)False

Question 19

The transaction processor at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

Accepted Answer

A) True 
 B)False

Question 20

Snapshot replication is most appropriate for:

Accepted Answer

A)  a data warehouse application. 
B)  an application where the processing of data follows a workflow across the business units. 
C)  a transaction processing system. 
D)  a spreadsheet application. 
A)  a data warehouse application. 
B)  an application where the processing of data follows a workflow across the business units. 
C)  a transaction processing system. 
D)  a spreadsheet application.

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

The reliability of a decentralized distributed database system with independent partitions is poor.

With an asynchronous distributed database, all data across the network is continuously kept up to date.

A remote unit of work allows updates at the single remote computer.

In a semijoin, all of the selected attributes from every selected row are transmitted to each site.

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

Users of distributed database systems always need to know the location of the data.

Applications that can tolerate out-of-date data are not the best candidates for data replication.

The purpose of time-stamping is to allow transactions to be processed in parallel.

Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.

Which of the following characterizes homogeneous environments?

Scalability is the ability to grow, reduce in size, and become more heterogeneous as the needs of the business change.

In a homogeneous environment, the same DBMS is used at each location.

Which of the following is true of data replication?

The step in which a distributed database decides the order in which to execute the distributed query is called:

A distributed unit of work does not support location transparency.

A distributed request allows a single SQL statement to refer to tables in more than one remote DBMS.

Replicated databases usually result in tightly coupled nodes.

The transaction processor at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

Snapshot replication is most appropriate for:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Object-Oriented Data Modeling

Filters

Exam 13: Distributed Databases

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

The reliability of a decentralized distributed database system with independent partitions is poor.

With an asynchronous distributed database, all data across the network is continuously kept up to date.

A remote unit of work allows updates at the single remote computer.

In a semijoin, all of the selected attributes from every selected row are transmitted to each site.

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

Users of distributed database systems always need to know the location of the data.

Applications that can tolerate out-of-date data are not the best candidates for data replication.

The purpose of time-stamping is to allow transactions to be processed in parallel.

Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.

Which of the following characterizes homogeneous environments?

Scalability is the ability to grow, reduce in size, and become more heterogeneous as the needs of the business change.

In a homogeneous environment, the same DBMS is used at each location.

Which of the following is true of data replication?

The step in which a distributed database decides the order in which to execute the distributed query is called:

A distributed unit of work does not support location transparency.

A distributed request allows a single SQL statement to refer to tables in more than one remote DBMS.

Replicated databases usually result in tightly coupled nodes.

The transaction processor at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

Snapshot replication is most appropriate for:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Object-Oriented Data Modeling

Filters