CSE :: Database System 2 - CS
- A distributed database is which of the following?
- A semijoin is which of the following?
- Which of the following is a disadvantage of replication?
- A distributed database can use which of the following strategies?
- Which of the following is not one of the stages in the evolution of distributed DBMS?
- With failure transparency, all of the actions of a transaction are committed or none of them are committed.
- Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.
- Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.
- Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
- With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.
|
A.
A single logical database that is spread to multiple locations and is interconnected by a network |
|
B.
A loose collection of file that is spread to multiple locations and is interconnected by a network |
|
C.
A single logical database that is limited to one location. |
|
D.
A loose collection of file that is limited to one location. |
Whatsapp
Facebook
|
A.
Only the joining attributes are sent from one site to another and then all of the rows are returned. |
|
B.
All of the attributes are sent from one site to another and then only the required rows are returned. |
|
C.
Only the joining attributes are sent from one site to another and then only the required rows are returned. |
|
D.
All of the attributes are sent from one site to another and then only the required rows are returned. |