CSE :: Database System 2 - CS
- A distributed database has which of the following advantages over a centralized database?
- An autonomous homogenous environment is which of the following?
- A transaction manager is which of the following?
- Location transparency allows for which of the following?
- A heterogeneous distributed database is which of the following?
- Some of the columns of a relation are at different sites is which of the following?
- Which of the following is true concerning a global transaction?
- A homogenous distributed database is which of the following?
- Replication should be used when which of the following exist?
- Storing a separate copy of the database at multiple locations is which of the following?
Whatsapp
Facebook
|
A.
The same DBMS is at each node and each DBMS works independently. |
|
B.
The same DBMS is at each node and a central DBMS coordinates database access. |
|
C.
A different DBMS is at each node and each DBMS works independently. |
|
D.
A different DBMS is at each node and a central DBMS coordinates database access. |
|
A.
The same DBMS is used at each location and data are not distributed across all nodes. |
|
B.
The same DBMS is used at each location and data are distributed across all nodes. |
|
C.
A different DBMS is used at each location and data are not distributed across all nodes. |
|
D.
A different DBMS is used at each location and data are distributed across all nodes. |
|
A.
The required data are at one local site and the distributed DBMS routes requests as necessary. |
|
B.
The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary. |
|
C.
The required data are at one local site and the distributed DBMS passes the request to only the local DBMS. |
|
D.
The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. |
|
A.
The same DBMS is used at each location and data are not distributed across all nodes. |
|
B.
The same DBMS is used at each location and data are distributed across all nodes. |
|
C.
A different DBMS is used at each location and data are not distributed across all nodes. |
|
D.
A different DBMS is used at each location and data are distributed across all nodes. |