Question 1

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

Accepted Answer

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

Question 2

____ 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 3

A distributed ____ allows a transaction to reference several different remote database processing sites.

Accepted Answer

A)  request 
B)  site 
C)  data location 
D)  transaction

Question 4

____ is a disadvantage of a DDBMS.

Accepted Answer

A)  Processor independence 
B)  The graphical user interface 
C)  Security 
D)  Data access that is too rapid

Question 5

The ____ guarantees that if a portion of a transaction operation cannot be committed,all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Accepted Answer

A)  DO-UNDO-REDO protocol 
B)  two-phase commit protocol (2P
C)  
C)  coordinator protocol 
D)  write-ahead protocol

Question 6

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 7

One of the advantages of a DDBMS is growth facilitation.

Accepted Answer

A) True 
 B)False

Question 8

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 9

A transaction processor is also known as the ____________________ processor.

Accepted Answer

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

Question 10

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

Exam 12: Distributed Database Management Systems