Question 1

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. 
A)  efficiency. 
B)  security. 
C)  ease of querying. 
D)  easier to set up than horizontal partitioning.

Question 2

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 
A)  Centralized; maximum 
B)  Centralized; minimum 
C)  Homogeneous; nonautonomous 
D)  Federated; nonautonomous

Question 3

Shared ownership of data is most appropriate as business activities move across time zones.

Accepted Answer

A) True 
 B)False

Question 4

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

Accepted Answer

A)  read-only commit. 
B)  lazy commit. 
C)  sequenced commit. 
D)  linear set up. 
A)  read-only commit. 
B)  lazy commit. 
C)  sequenced commit. 
D)  linear set up.

Question 5

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 6

A distributed unit of work does not support location transparency.

Accepted Answer

A) True 
 B)False

Question 7

Organizational forces such as funding availability drive the choice of distributed database strategy.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

________ 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 
A)  Location transparency 
B)  Location autonomy 
C)  Location dependency 
D)  Distributed locatability

Question 10

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

Accepted Answer

The answer of ________ is the ability to grow,reduce in...

Question 11

Describe the range of distributed database environments

Accepted Answer

The range of distributed databases fall

Question 12

Which of the following are factors in deciding on database distribution strategies?

Accepted Answer

A)  Organizational forces 
B)  Frequency of data access 
C)  Reliability needs 
D)  All of the above 
A)  Organizational forces 
B)  Frequency of data access 
C)  Reliability needs 
D)  All of the above

Question 13

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 14

Which of the following environments uses a different DBMS at each node,and supports local databases for unique data requests?

Accepted Answer

A)  Gateways; local 
B)  Centralized; minimum 
C)  Homogeneous; cross-linked 
D)  Heterogeneous; federated 
A)  Gateways; local 
B)  Centralized; minimum 
C)  Homogeneous; cross-linked 
D)  Heterogeneous; federated

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A distributed database must:

Accepted Answer

A)  keep track of data locations. 
B)  present a single logical database that is physically distributed. 
C)  provide consistency among data copies. 
D)  all of the above. 
A)  keep track of data locations. 
B)  present a single logical database that is physically distributed. 
C)  provide consistency among data copies. 
D)  all of the above.

Question 17

Which of the following is an advantage to data replication?

Accepted Answer

A)  Reliability 
B)  Fast response 
C)  Node decoupling 
D)  All of the above 
A)  Reliability 
B)  Fast response 
C)  Node decoupling 
D)  All of the above

Question 18

A transaction that requires reference to data at one or more nonlocal sites to satisfy the request is a(n)________ transaction.

Accepted Answer

The answer of A transaction that requires reference to data...

Question 19

What are the five unique ways that a data distribution strategy can be organized?

Accepted Answer

A distributed database can be organized

Question 20

Which of the following is true of distributed databases?

Accepted Answer

A)  Less reliable 
B)  Better local control 
C)  Slower response time 
D)  None of the above 
A)  Less reliable 
B)  Better local control 
C)  Slower response time 
D)  None of the above

All of the following are advantages of vertical partitioning EXCEPT:

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

Shared ownership of data is most appropriate as business activities move across time zones.

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

Which of the following characterizes homogeneous environments?

A distributed unit of work does not support location transparency.

Organizational forces such as funding availability drive the choice of distributed database strategy.

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

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

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

Describe the range of distributed database environments

Which of the following are factors in deciding on database distribution strategies?

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

Which of the following environments uses a different DBMS at each node,and supports local databases for unique data requests?

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

A distributed database must:

Which of the following is an advantage to data replication?

A transaction that requires reference to data at one or more nonlocal sites to satisfy the request is a(n)________ transaction.

What are the five unique ways that a data distribution strategy can be organized?

Which of the following is true of distributed databases?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 12: Distributed Databases

All of the following are advantages of vertical partitioning EXCEPT:

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

Shared ownership of data is most appropriate as business activities move across time zones.

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

Which of the following characterizes homogeneous environments?

A distributed unit of work does not support location transparency.

Organizational forces such as funding availability drive the choice of distributed database strategy.

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

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

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

Describe the range of distributed database environments

Which of the following are factors in deciding on database distribution strategies?

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

Which of the following environments uses a different DBMS at each node,and supports local databases for unique data requests?

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

A distributed database must:

Which of the following is an advantage to data replication?

A transaction that requires reference to data at one or more nonlocal sites to satisfy the request is a(n)________ transaction.

What are the five unique ways that a data distribution strategy can be organized?

Which of the following is true of distributed databases?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters