Exam 17: Client-Server Processing and Distributed Databases

In a(n)_____________________ architecture,a PC client and a database server interact directly to request and transfer data.

___________________ is a concurrency control protocol for distributed transactions in which write locks are necessary only for the replicated fragment that has been designated as the primary copy.

Scalability refers to the ease of maintaining and adapting a system.

When a distributed DBMS is tightly integrated,which of the following statements is not true?

In a distributed DBMS:

An overriding design issue in client-server database architecture is:

In parallel database processing one of the standard classifications of architecture is referred to as shared everything (SE).Which of the statements below is true of the SE architecture?

Vertical fragments can be defined using projection operations.

A level of data independence in distributed DBMSs in which queries must specify the fragments and their locations,but not their local format,is known as _____________________.

In a(n)____________________ architecture,division of processing problems are addressed by the addition of a middleware server and one or more application servers.

To extend its existing non-distributed DBMS to a tightly-integrated distributed DBMS,a business needs only to buy an extra component from a third-party vendor or the DBMS vendor.

The server-side approach has the following feature:

In a client-server database architecture which of the following is not a middleware function?

A ________ DBMS is a DBMS capable of utilizing tightly-coupled computing resources (processors,disks,and memory).Tight coupling is achieved by networks with data exchange time comparable to the time of the data exchange with a disk.

In distributed transaction processing,transactions do not necessarily have to conform to all of the ACID properties that non-distributed transactions do.

The Web Services Architecture uses the HTTP,FTP,and TCP-IP protocols for sending and receiving XML messages.

Clients and servers can exist on platforms with different hardware and operating systems,but they must use the same DBMSs and programming languages to be interoperable.

A level of data independence in distributed DBMSs in which queries can be formulated without knowing the locations or local formats of the fragments is _______________________.

In a three-tier client-server database architecture,the "third tier" is:

In a two-tier client-server architecture,the PC client contains the user interface code,the server contains the data access logic,and the client and server share the validation and business logic.