Exam 12: Clientserver Database and Distributed Database

What client/server database and distributed database have in common is that in both cases the databases can be located other than "in the computer itself."

The term "client" in a local area network refers to the larger computer with the shared database that all of the PCs on the network can access.

All of the following are true when there is targeted data replication on a distributed database network, except ____.

When data is distributed in a distributed database arrangement, the database is no longer considered to be a single, logical database.

All of the following are true when dispersing tables on a distributed database network without data replication or partitioning, except ____.

In the database server approach to client/server database, the actual database processing is done at the server.

If node A on a distributed database network issues a query that requires tables at nodes B, C, and D, the least likely site for the join to take place is node ____.

In general, the directory of a distributed database ____.

If data replication is permitted in a distributed database network ____.

An advantage of targeted data replication in a distributed database network is reduced communications costs for read-only data access.

Distributed directories are necessary in a distributed database environment in order to achieve location transparency.

One of the principles of data replication in a distributed database is to place copies of tables at the sites that use them most heavily in order to minimize telecommunications costs.

In the database server approach to client/server database, when a client computer on the LAN needs to query, update, or otherwise use a file on the server ____.

One of the principles of data replication in a distributed database is to ensure that there are at least two copies of important or frequently used tables to realize the gains in availability.

In the prepare phase of the two-phase commit process, the updated data is written to a log at each site but not to the database at each site.

In a distributed join situation, the only way that the join can be accomplished is to transmit the records involved from their sites to the initiating site where the join must take place.