Can someone answer these database questions? 1 - The _____ processor is the soft
ID: 3842955 • Letter: C
Question
Can someone answer these database questions?
1 - The _____ processor is the software component found in each computer that requests data. It receives and processes the application's data requests.
2 - In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.
3 - Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.
4 - _____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.
5 - A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
6 - A DDBMS is subject to which of the following restrictions?
7 - _____ transparency allows a physically dispersed database to be managed as though it were centralized.
8 - _____ transparency allows data to be updated simultaneously at several network sites.
9 - _____ transparency allows the system to operate as if it were a centralized database management system.
10 - _____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.
11 - _____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
12 - A _____ contains the description of the entire database as seen by the database administrator.
13 - _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.
14 - A distributed _____ can reference several different local or remote data processing sites.
15 - A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.
16 - The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.
Explanation / Answer
1. transaction
2. DP (data processor)
3. multiple-site processing, single-site data
4. Homogeneous
5. fully heterogeneous
6. Remote data access is provided on a read-only basis.
7. Distribution
8. Transaction
9. performance
10. fragmentation
11. location
12.distributed data dictionary
13. remote request
14. data location
15. request
16. two-phase commit protocol