Distributed Databases problems
- 1. A semijoin is which of the following?
Options- 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. Discuss
Correct Answer: Only the joining attributes are sent from one site to another and then only the required rows are returned.
- 2. A heterogeneous distributed database is which of the following?
Options- 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. Discuss
Correct Answer: A different DBMS is used at each location and data are distributed across all nodes.
- 3. Storing a separate copy of the database at multiple locations is which of the following?
Options- A. Data Replication
- B. Horizontal Partitioning
- C. Vertical Partitioning
- D. Horizontal and Vertical Partitioning Discuss
Correct Answer: Data Replication
- 4. Which of the following is not one of the stages in the evolution of distributed DBMS?
Options- A. Unit of work
- B. Remote unit of work
- C. Distributed unit of Work
- D. Distributed request Discuss
Correct Answer: Unit of work
- 5. A distributed database can use which of the following strategies?
Options- A. Totally centralized at one location and accessed by many sites
- B. Partially or totally replicated across sites
- C. Partitioned into segments at different sites
- D. All of the above Discuss
Correct Answer: All of the above
- 6. 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.
Options- A. True
- B. False Discuss
Correct Answer: True
- 7. Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
Options- A. True
- B. False Discuss
Correct Answer: False
- 8. A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.
Options- A. True
- B. False Discuss
Correct Answer: True
- 9. The purpose of timestamping is to avoid the use of locks.
Options- A. True
- B. False Discuss
Correct Answer: True
- 10. The problem of concurrency control is more complex in a distributed database.
Options- A. True
- B. False Discuss
Correct Answer: True
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.