A transaction manager is which of the following? Maintains a log of transactions Maintains before and after database images Maintains appropriate concurrency control All of these TRUE ANSWER : ? YOUR ANSWER : ?
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned. True False TRUE ANSWER : ? YOUR ANSWER : ?
Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment. False True TRUE ANSWER : ? YOUR ANSWER : ?
Location transparency allows for which of the following? Programmers to treat the data as if it is at one location Users to treat the data as if it is at one location Managers to treat the data as if it is at one location All of these TRUE ANSWER : ? YOUR ANSWER : ?
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. False True TRUE ANSWER : ? YOUR ANSWER : ?
A distributed database can use which of the following strategies? Partially or totally replicated across sites Partitioned into segments at different sites All of these Totally centralized at one location and accessed by many sites TRUE ANSWER : ? YOUR ANSWER : ?
With failure transparency, all of the actions of a transaction are committed or none of them are committed. False True TRUE ANSWER : ? YOUR ANSWER : ?
A semijoin is which of the following? Only the joining attributes are sent from one site to another and then all of the rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then only the required rows are returned. TRUE ANSWER : ? YOUR ANSWER : ?
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations. False True TRUE ANSWER : ? YOUR ANSWER : ?