Question 1

The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

Accepted Answer

The answer of The database description, known as the distributed...

Question 2

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

Accepted Answer

A) True 
 B)False

Question 3

A remote transaction, composed of several requests, may access data at multiple sites.

Accepted Answer

A) True 
 B)False

Question 4

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

Accepted Answer

A)  transaction 
B)  network 
C)  data 
D)  management

Question 5

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

Accepted Answer

A)  Local mapping 
B)  Location 
C)  Performance 
D)  Transaction

Question 6

The ____________________ fragment condition indicates that each row is unique, regardless of the fragment in which it is located.

Accepted Answer

The answer of The ____________________ fragment condition indicates that each...

Question 7

____ transparency allows the integration of several different local DBMSs under a common, or global, schema.

Accepted Answer

A)  Transaction 
B)  Performance 
C)  Distribution 
D)  Heterogeneity

Question 8

____ distributed database systems integrate different types of centralized DBMSs over a network.

Accepted Answer

A)  Homogeneous 
B)  Heterogeneous 
C)  Fully homogeneous 
D)  Combination

Question 9

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

Accepted Answer

A)  distributed 
B)  transaction 
C)  fragmented 
D)  transparent

Question 10

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

Accepted Answer

A) True 
 B)False

Question 11

A user-friendly ____________________ is one advantage of a DDBMS.

Accepted Answer

The answer of A user-friendly ____________________ is one advantage of...

Question 12

Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____ database stores each database fragment at a single site.

Accepted Answer

A)  partially replicated 
B)  unreplicated 
C)  fully replicated 
D)  partitioned

Question 14

Typically, the __________________________________________________ scenario requires a network file server running conventional applications that are accessed through a network.

Accepted Answer

The answer of Typically, the __________________________________________________ scenario requires a network...

Question 15

A ____ contains the description of the entire database as seen by the database administrator.

Accepted Answer

A)  distributed global dictionary 
B)  distributed data dictionary 
C)  distributed global schema 
D)  distributed data schema

Question 16

A DDBMS must be communications-media-dependent.

Accepted Answer

A) True 
 B)False

Question 17

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

Accepted Answer

The answer of One of the advantages of a DDBMS...

Question 18

In a DDBMS, query ____________________ is used to find the best access strategy.

Accepted Answer

The answer of In a DDBMS, query ____________________ is used...

Question 19

A transaction processor is also known as the ____________________ processor.

Accepted Answer

The answer of A transaction processor is also known as...

Question 20

The ____ processor is the software component found in each computer that requests data. It receives and processes the application's data requests.

Accepted Answer

A)  database 
B)  transaction 
C)  data 
D)  network

Exam 10: Distributed Databases

The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

A remote transaction, composed of several requests, may access data at multiple sites.

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

The ____________________ fragment condition indicates that each row is unique, regardless of the fragment in which it is located.

____ transparency allows the integration of several different local DBMSs under a common, or global, schema.

____ distributed database systems integrate different types of centralized DBMSs over a network.

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

A user-friendly ____________________ is one advantage of a DDBMS.

Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.

A(n) ____ database stores each database fragment at a single site.

Typically, the __________________________________________________ scenario requires a network file server running conventional applications that are accessed through a network.

A ____ contains the description of the entire database as seen by the database administrator.

A DDBMS must be communications-media-dependent.

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

In a DDBMS, query ____________________ is used to find the best access strategy.

A transaction processor is also known as the ____________________ processor.

The ____ processor is the software component found in each computer that requests data. It receives and processes the application's data requests.