Chat with AIExam 13: Distributed Databases
Shared ownership of data is most appropriate as business activities move across time zones.
(31) 
VerifiedFalse
What are the functions of a distributed DBMS?
(38) VerifiedIn a distributed database environment, the local database at each site will have a DBMS managing the local database. However, there is a centralized DBMS which handles the following:
1. Keeping track of where data are located in the distributed data dictionary
2. Determine the location from which to retrieve requested data and the location at which to process each part of a distributed query
3. Translate the request at one node using a local DBMS into a request at another node, perhaps using a different DBMS
4. Provide security, concurrency, deadlock control and other data management functions
5. Provide consistency among copies of data across multiple sites
6. Provide a single logical database that is physically distributed
7. Provide scalability
8. Replicate data and stored procedures across the nodes of the distributed database
9. Use residual computing power to improve the performance of database processing
10. Permit different nodes to run different DBMSs
11. Allow different versions of application code to reside on different nodes of the distributed database
With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.
(37) VerifiedFalse
Which of the following environments uses a different DBMS at each node and supports local databases for unique data requests?
(45) A synchronized replication strategy has a(n) ________ reliability.
(37) A distributed database is a single logical database spread physically across computers in multiple locations that are connected by a data communication link.
(37) In general, data should be located away from the applications that use those data.
(34) A design goal for distributed databases that states that although a distributed database runs many transactions, it appears that a given transaction is the only one in the system is called:
(44) ________ is a design goal for a distributed database that says a site can independently administer and operate its database.
(23) One way to generate messages for near-real-time replication is through the use of database triggers.
(34) Local autonomy means that data are not accessible from remote sites.
(33) A form of distributed database in which all data across a network are kept continuously updated, so a user can access any data anywhere on the network and get the same answer is called a(n) ________ distributed database.
(33) One way to generate, store, and forward messages for completed transactions to be broadcast across a network is through the use of:
(33) In a push replication strategy, the target, not the source, controls when a local database is updated.
(38) A transaction that requires reference to data at one or more nonlocal sites to satisfy the request is a global transaction.
(33) Two-phase commit is an algorithm for coordinating deletions in a distributed database management system.
(41) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)