Question 1

_______________________ can be used to provide a uniform interface between relational and non-relational data using SQL.

Accepted Answer

The answer of _______________________ can be used to provide a...

Question 2

A protocol used for distributed commit processing in which the coordinator site and participant sites act in unison to decide to commit or abort their sub-transactions is known as the _________________.

Accepted Answer

The answer of A protocol used for distributed commit processing...

Question 3

In a three-tier client-server database architecture,the application server typically will contain:

Accepted Answer

A)  Specialized software such as report writing 
B)  Business logic 
C)  Transaction processing software 
D)  Data validation

Question 4

_______________ provide a high level of interoperability and message intelligence.They also resolve platform differences between a client and a server.

Accepted Answer

The answer of _______________ provide a high level of interoperability...

Question 5

Message-oriented middleware provides built-in intelligence but use simple messages.In contrast,transaction-processing monitors provide much less built-in intelligence but support more complex messages.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is a design issue that affects the design of a client-server database?

Accepted Answer

A)  division of processing 
B)  distribution of storage of data 
C)  process management 
D)  A and C

Question 7

The ______________optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.

Accepted Answer

The answer of The ______________optimizes query execution across sites,coordinates concurrency...

Question 8

A(n)_______________________,the oldest kind of middleware,relieves the operating system of managing database processes.

Accepted Answer

The answer of A(n)_______________________,the oldest kind of middleware,relieves the operating...

Question 9

In a client-server architecture,____________code is code to ensure the consistency of the database and user inputs.

Accepted Answer

The answer of In a client-server architecture,____________code is code to...

Question 10

The design and allocation of fragments require data about:

Accepted Answer

A)  Frequencies of queries 
B)  Frequencies of parameter values 
C)  Frequencies of originating sites for each query 
D)  All of the above

Question 11

In a tightly integrated distributed DBMS,the fragmentation schema contains the definition of each fragment and the allocation schema contains the location of each fragment.

Accepted Answer

A) True 
 B)False

Question 12

XML is a meta language that supports the specification of other languages.

Accepted Answer

A) True 
 B)False

Question 13

A ___________ is a tight coupling of two or more computers so that they behave as a single computer.

Accepted Answer

The answer of A ___________ is a tight coupling of...

Question 14

The primary design issues that influence the performance of the parallel database architectures include which of the following?

Accepted Answer

A)  load balancing 
B)  cache coherence 
C)  interprocessor communication 
D)  all of the above

Question 15

Which of the following is not a kind of middleware?

Accepted Answer

A)  transaction-processing monitors 
B)  message-oriented middleware 
C)  object-request brokers 
D)  Meta data repository hyper-access utilities

Question 16

Which of the following is not a typical example of flexibility provided by a client-server approach with distributed processing?

Accepted Answer

A)  Easily change the database language 
B)  Change the user interface for the sales department 
C)  Supports reusability through object orientation 
D)  Make a user interface for the newly created position of human resources advisor

Question 17

Some of the disadvantages of distributed data are increased data duplication,a higher complexity of database design,and a higher complexity of providing security for data distributed among multiple sites.

Accepted Answer

A) True 
 B)False

Question 18

In a(n)____________________ architecture,performance is improved by the addition of either a middleware server or an application server.

Accepted Answer

The answer of In a(n)____________________ architecture,performance is improved by the...

Question 19

Which of the following statements is true about parallel and distributed databases with respect to autonomy?

Accepted Answer

A)  Parallel databases provide site autonomy while distributed databases do not. 
B)  Distributed databases provide site autonomy while parallel databases do not. 
C)  There is no difference between parallel databases and distributed databases with respect to autonomy. 
D)  Autonomy of the database is dependent on the DBMS vendor not its architecture.

Question 20

_________________ is a software component in a client-server architecture that performs process management.

Accepted Answer

The answer of _________________ is a software component in a...

Exam 17: Client-Server Processing and Distributed Databases

_______________________ can be used to provide a uniform interface between relational and non-relational data using SQL.

A protocol used for distributed commit processing in which the coordinator site and participant sites act in unison to decide to commit or abort their sub-transactions is known as the _________________.

In a three-tier client-server database architecture,the application server typically will contain:

_______________ provide a high level of interoperability and message intelligence.They also resolve platform differences between a client and a server.

Message-oriented middleware provides built-in intelligence but use simple messages.In contrast,transaction-processing monitors provide much less built-in intelligence but support more complex messages.

Which of the following is a design issue that affects the design of a client-server database?

The ______________optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.

A(n)_______________________,the oldest kind of middleware,relieves the operating system of managing database processes.

In a client-server architecture,____________code is code to ensure the consistency of the database and user inputs.

The design and allocation of fragments require data about:

In a tightly integrated distributed DBMS,the fragmentation schema contains the definition of each fragment and the allocation schema contains the location of each fragment.

XML is a meta language that supports the specification of other languages.

A ___________ is a tight coupling of two or more computers so that they behave as a single computer.

The primary design issues that influence the performance of the parallel database architectures include which of the following?

Which of the following is not a kind of middleware?

Which of the following is not a typical example of flexibility provided by a client-server approach with distributed processing?

Some of the disadvantages of distributed data are increased data duplication,a higher complexity of database design,and a higher complexity of providing security for data distributed among multiple sites.

In a(n)____________________ architecture,performance is improved by the addition of either a middleware server or an application server.

Which of the following statements is true about parallel and distributed databases with respect to autonomy?

_________________ is a software component in a client-server architecture that performs process management.