Home » DBMS » Distributed Databases
Computer Science is the study of how we can use computers to process and store data. The field encompasses a wide range of topics, from database management systems (DBMSs) to artificial intelligence (AI).
1: A _____ DBMS distributes data processing tasks between the workstation and a network server. a. Network b. Relational c. Client Server d. Hierarchical
Show Answer Answer: (c). Client Server
2: A benefit of the three-tier architecture is which of the following? a. New modules can be built to support specific business needs b. Performance improves for compiled SQL statements c. Results in a thinner client and database server d. All of the above.
Show Answer Answer: (a). New modules can be built to support specific business needs
3: A characteristic of a file server is which of the following? a. Manages file operations and is shared on a network. b. Manages file operations and is limited to one PC. c. Acts as a fat client and is shared on a network. d. Acts as a fat client and is limited to one PC.
Show Answer Answer: (a). Manages file operations and is shared on a network.
4: A database server is responsible for which of the following? a. Database storage b. Data processing logic c. Data presentation logic d. All of the above.
Show Answer Answer: (a). Database storage
5: A distributed database can use which of the following strategies? 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
Show Answer Answer: (d). All of the above
6: A distributed database has which of the following advantages over a centralized database? a. Software cost b. Software complexity c. Slow Response d. Modular growth
Show Answer Answer: (d). Modular growth
7: A distributed database is which of the following? 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.
Show Answer Answer: (a). A single logical database that is spread to multiple locations and is interconnected by a network
8: A distributed transaction can be . if ries are issued at one or more nodes. a. fully read-only b partially read-only c. fully read-write d. partially read-write
Show Answer Answer: (b). partially read-only
9: A heterogeneous distributed database is which of the following? 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.
Show Answer Answer: (d). A different DBMS is used at each location and data are distributed across all nodes.
10: A homogeneous distributed database is which of the following? 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.
Show Answer Answer: (b). The same DBMS is used at each location and data are distributed across all nodes.