Discussion
Home ‣ Database ‣ Distributed Databases Comments
- Question
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.
- Correct Answer
- A different DBMS is used at each location and data are distributed across all nodes.
- 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
- 2. Which of the following is true concerning a global transaction?
Options- 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. Discuss
- 3. A distributed database has which of the following advantages over a centralized database?
Options- A. Software cost
- B. Software complexity
- C. Slow Response
- D. Modular growth Discuss
- 4. Location transparency allows for which of the following?
Options- A. Users to treat the data as if it is at one location
- B. Programmers to treat the data as if it is at one location
- C. Managers to treat the data as if it is at one location
- D. All of the above. Discuss
- 5. Some of the columns of a relation are at different sites is which of the following?
Options- A. Data Replication
- B. Horizontal Partitioning
- C. Vertical Partitioning
- D. Horizontal and Vertical Partitioning Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. The keyword "inverse" is used in which of the following?
Options- A. Class
- B. Attribute
- C. Relationship
- D. All of the above. Discuss
- 10. The reserved word enum is used for which of the following?
Options- A. To define a range for an attribute.
- B. To define a range for a class.
- C. To define a range for a relationship.
- D. All of the above. Discuss
Distributed Databases problems
Search Results
Correct Answer: Only the joining attributes are sent from one site to another and then only the required rows are returned.
Correct Answer: The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
Correct Answer: Modular growth
Correct Answer: All of the above.
Correct Answer: Vertical Partitioning
Correct Answer: Data Replication
Correct Answer: Unit of work
Correct Answer: All of the above
Correct Answer: Relationship
Correct Answer: To define a range for an attribute.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.