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.