Question 1

________ is a design goal in distributed database systems,which says that even though a data item may be replicated at several nodes throughout the network,a user may treat the data item as if it were a single data item at a single node.

Accepted Answer

The answer of ________ is a design goal in distributed...

Question 2

A design goal for distributed databases that guarantees either all the actions or none of the actions in a transaction are committed is ________.

Accepted Answer

The answer of A design goal for distributed databases that...

Question 3

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

Accepted Answer

The answer of The ________ at each site maintains an...

Question 4

A distributed DBMS uses a(n)________ to predict the execution time of alternative execution plans.

Accepted Answer

The answer of A distributed DBMS uses a(n)________ to predict...

Question 5

Describe the range of distributed database environments

Accepted Answer

The answer of Describe the range of distributed database environments...

Question 6

In general,data should be located ________ to the applications that use those data.

Accepted Answer

The answer of In general,data should be located ________ to...

Question 7

A transaction that requires only reference to data that are stored at the site is a(n)________ transaction.

Accepted Answer

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

Question 8

A(n)________ enables a single SQL statement to refer to tables in more than one remote DBMS.

Accepted Answer

The answer of A(n)________ enables a single SQL statement to...

Question 9

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 10

________ simplifies a query and rewrites it into a structured,relational algebra form.

Accepted Answer

The answer of ________ simplifies a query and rewrites it...

Question 11

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

________ is implemented by placing some rows of a table at one site and other rows at another site.

Accepted Answer

The answer of ________ is implemented by placing some rows...

Question 13

________ enables users and programmers to treat data as if it were located at one node even though it may move from node to node.

Accepted Answer

The answer of ________ enables users and programmers to treat...

Question 14

An optimization strategy that permits each part of a transaction to be committed in sequence is called ________ optimization.

Accepted Answer

The answer of An optimization strategy that permits each part...

Question 15

An algorithm designed to ensure that updates in a distributed database are coordinated is called a(n)________.

Accepted Answer

The answer of An algorithm designed to ensure that updates...

Question 16

Explain the difference between a synchronous and asynchronous distributed database.

Accepted Answer

The answer of Explain the difference between a synchronous and...

Question 17

What business conditions encourage the use of distributed databases?

Accepted Answer

The answer of What business conditions encourage the use of...

Question 18

A distributed unit of work allows various statements within a unit of work to refer to ________ remote DBMS locations.

Accepted Answer

The answer of A distributed unit of work allows various...

Question 19

A(n)________ is a joining operation used with distributed databases in which only the joining attribute from one site is transmitted to the other site.

Accepted Answer

The answer of A(n)________ is a joining operation used with...

Question 20

________ is an alternative to the use of locks in a distributed database.

Accepted Answer

The answer of ________ is an alternative to the use...

Quiz 12: Distributed Databases