Question: Can someone answer these database questions? 1 - The _____ processor is the software component found in each computer that requests data. It receives and

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!