Question 1

A form of distributed database in which all data across a network are kept continuously updated, so a user can access any data anywhere on the network and get the same answer is called a(n) ________ distributed database.

Accepted Answer

A)  synchronous 
B)  asynchronous 
C)  private 
D)  cloud-based

Question 2

Two-phase commit is an algorithm for coordinating deletions in a distributed database management system.

Accepted Answer

A) True 
 B)False

Question 3

With a pull strategy of replication, the ________ node determines when a database is updated.

Accepted Answer

A)  user 
B)  source 
C)  target 
D)  banner

Question 4

Combining data across vertical partitions is generally more difficult than combining across horizontal partitions.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following are business conditions that encourage the use of distributed databases?

Accepted Answer

A)  Companies with less than 10 employees 
B)  Lack of Data sharing needs 
C)  Data communication reliability 
D)  Companies that only store data on spreadsheets

Question 6

An environment in which data are distributed across all nodes, and there is a global schema, is called a(n) heterogenous environment.

Accepted Answer

A) True 
 B)False

Question 7

The sequence of instructions required to process a transaction is called the:

Accepted Answer

A)  unit of work. 
B)  logical program unit. 
C)  rollback. 
D)  commit.

Question 8

All of the following are advantages of vertical partitioning EXCEPT:

Accepted Answer

A)  efficiency. 
B)  security. 
C)  ease of querying. 
D)  easier to set up than horizontal partitioning.

Question 9

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.

Question 10

________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.

Accepted Answer

A)  Location transparency 
B)  Location autonomy 
C)  Location dependency 
D)  Distributed locatability

Question 11

Data localization involves transforming a query into fragments that explicitly reference data at one site.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?

Accepted Answer

A)  Centralized; maximum 
B)  Centralized; minimum 
C)  Homogeneous; nonautonomous 
D)  Federated; nonautonomous

Question 13

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 14

Which of the following supports a simple path to other databases, without the benefits of one logical database?

Accepted Answer

A)  Linked; differential 
B)  Gateways 
C)  Autonomous; cross-linked 
D)  Federated; nonautonomous

Question 15

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.

Question 16

What is data replication?

Accepted Answer

The answer of What is data replication?...

Question 17

Concurrency transparency allows each transaction to appear as if it were the only activity in a distributed database management system.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Simple paths to other databases without the benefits of one logical database are called:

Accepted Answer

A)  freeways. 
B)  parkways. 
C)  gateways. 
D)  highways.

Question 20

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

Exam 13: Distributed Databases

A form of distributed database in which all data across a network are kept continuously updated, so a user can access any data anywhere on the network and get the same answer is called a(n) ________ distributed database.

Two-phase commit is an algorithm for coordinating deletions in a distributed database management system.

With a pull strategy of replication, the ________ node determines when a database is updated.

Combining data across vertical partitions is generally more difficult than combining across horizontal partitions.

Which of the following are business conditions that encourage the use of distributed databases?

An environment in which data are distributed across all nodes, and there is a global schema, is called a(n) heterogenous environment.

The sequence of instructions required to process a transaction is called the:

All of the following are advantages of vertical partitioning EXCEPT:

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

________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.

Data localization involves transforming a query into fragments that explicitly reference data at one site.

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?

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 supports a simple path to other databases, without the benefits of one logical database?

Snapshot replication is most appropriate for:

What is data replication?

Concurrency transparency allows each transaction to appear as if it were the only activity in a distributed database management system.

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

Simple paths to other databases without the benefits of one logical database are called:

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