Miguel Lucero
Quiz by , created more than 1 year ago

CIS 3365 Quiz on CHAPTER 12: DISTRIBUTED DATABASE MANAGEMENT SYSTEMS, created by Miguel Lucero on 06/04/2017.

478
2
0
Miguel Lucero
Created by Miguel Lucero over 7 years ago
Close

CHAPTER 12: DISTRIBUTED DATABASE MANAGEMENT SYSTEMS

Question 1 of 50

1

1. A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.

Select one of the following:

  • True
  • False

Explanation

Question 2 of 50

1

2. Distributed data access was needed to support geographically dispersed business units.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 50

1

3. Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 50

1

4. The Internet is the repository for distributed data.

Select one of the following:

  • True
  • False

Explanation

Question 5 of 50

1

5. Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control

Select one of the following:

  • True
  • False

Explanation

Question 6 of 50

1

6. Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

Select one of the following:

  • True
  • False

Explanation

Question 7 of 50

1

7. One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.

Select one of the following:

  • True
  • False

Explanation

Question 8 of 50

1

8. One of the advantages of a distributed database management system (DDBMS) is growth facilitation.

Select one of the following:

  • True
  • False

Explanation

Question 9 of 50

1

9. One of the advantages of a distributed database management system (DDBMS) is security.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 50

1

10. Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 50

1

11. In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.

Select one of the following:

  • True
  • False

Explanation

Question 12 of 50

1

12. A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 50

1

13. A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

Select one of the following:

  • True
  • False

Explanation

Question 14 of 50

1

14. The transaction processor (TP) is the software component found in each computer that requests data.

Select one of the following:

  • True
  • False

Explanation

Question 15 of 50

1

15. A distributed database management system (DDBMS) must be communications-media-dependent.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 50

1

16. A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site.

Select one of the following:

  • True
  • False

Explanation

Question 17 of 50

1

17. In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 50

1

18. Performance transparency ensures that the system finds the most cost-effective path to access remote data.

Select one of the following:

  • True
  • False

Explanation

Question 19 of 50

1

The level of transparency supported by the distributed database management system remains the same for all systems.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 50

1

20. Distribution transparency is supported by a distributed data dictionary.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 50

1

21. Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 50

1

22. A remote transaction, composed of several requests, may access data at multiple sites.

Select one of the following:

  • True
  • False

Explanation

Question 23 of 50

1

23. A centralized database management is subject to a problem such as____________

Select one of the following:

  • a. a growing number of remote locations

  • b. maintaining and operating small database systems

  • c. dependence on multiple sites

  • d. organizational flexibility of the database

Explanation

Question 24 of 50

1

24. A disadvantage of a distributed database management system (DDBMS) is that:

Select one of the following:

  • a. it is slower in terms of data access.

  • b. adding new sites affects other sites' operations.

  • c. it is processor dependent.

  • d. there are lack of standards.

Explanation

Question 25 of 50

1

25. A distributed database is composed of several parts known as database .

Select one of the following:

  • a. sections

  • b. fragments

  • c. partitions

  • d. parts

Explanation

Question 26 of 50

1

26. Distributed processing does not require

Select one of the following:

  • a. database processing functions to be distributed to all data storage sites.

  • b. an existing distributed database.

  • c. a network of interconnected components.

  • d. multiple sites to share processing chores.

Explanation

Question 27 of 50

1

27. A database management system needs to prepare the data for presentation to the end user or to an application program.

Select one of the following:

  • a. security

  • b. concurrency control

  • c. formatting

  • d. I/O interface

Explanation

Question 28 of 50

1

28. The processor is the software component found in each computer that requests data. It receives and processes the application's data requests.

Select one of the following:

  • a. database

  • b. transaction

  • c. data

  • d. network

Explanation

Question 29 of 50

1

29. 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.

Select one of the following:

  • a. transaction processor

  • b. application processor

  • c. transaction manager

  • d. data processor

Explanation

Question 30 of 50

1

30. Under the scenario, all record- and file-locking activities are performed at the end-user location.

Select one of the following:

  • a. single-site processing, single-site data

  • b. multiple-site processing, single-site data

  • c. single-site processing, multiple-site data

  • d. multiple-site processing, multiple-site data

Explanation

Question 31 of 50

1

31. _____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.

Select one of the following:

  • a. Homogeneous

  • b. Heterogeneous

  • c. Fully heterogeneous

  • d. Combination

Explanation

Question 32 of 50

1

32. A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Select one of the following:

  • a. fully heterogeneous

  • b. fully homogeneous

  • c. homogeneous

  • d. heterogeneous

Explanation

Question 33 of 50

1

33. A DDBMS is subject to which of the following restrictions?

Select one of the following:

  • a. Multiple instances of the same database should be integrated over a network.

  • b. All database processing must be done at a single site.

  • c. Rapid ad hoc data access is not possible.

  • d. Remote data access is provided on a read-only basis.

Explanation

Question 34 of 50

1

34. transparency allows a physically dispersed database to be managed as though it were centralized.

Select one of the following:

  • a. Distribution

  • b. Transaction

  • c. Failure

  • d. Performance

Explanation

Question 35 of 50

1

35. transparency allows data to be updated simultaneously at several network sites.

Select one of the following:

  • a. Transaction

  • b. Distribution

  • c. Failure

  • d. Performance

Explanation

Question 36 of 50

1

36. transparency allows the system to operate as if it were a centralized database management system.

Select one of the following:

  • a. Heterogeneity

  • b. Distribution

  • c. Performance

  • d. Failure

Explanation

Question 37 of 50

1

transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

Select one of the following:

  • a. Performance

  • b. Fragmentation

  • c. Location

  • d. Local mapping

Explanation

Question 38 of 50

1

38. 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.

Select one of the following:

  • a. Transaction

  • b. Location

  • c. Local mapping

  • d. Fragmentation

Explanation

Question 39 of 50

1

39. A contains the description of the entire database as seen by the database administrator.

Select one of the following:

  • a. distributed global dictionary

  • b. distributed data dictionary

  • c. distributed global schema

  • d. distributed data schema

Explanation

Question 40 of 50

1

40. A lets a single SQL statement access the data that are to be processed by a single remote database processor.

Select one of the following:

  • a. remote request

  • b. remote transaction

  • c. distributed request

  • d. distributed transaction

Explanation

Question 41 of 50

1

41. A distributed can reference several different local or remote data processing sites.

Select one of the following:

  • a. request

  • b. site

  • c. data location

  • d. transaction

Explanation

Question 42 of 50

1

42. A request lets a single SQL statement reference data located at several different local or remote DP sites.

Select one of the following:

  • a. distributed

  • b. transaction

  • c. fragmented

  • d. remote

Explanation

Question 43 of 50

1

43. 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.

Select one of the following:

  • a. DO-UNDO-REDO protocol

  • b. two-phase commit protocol (2PC)

  • c. coordinator protocol

  • d. write-ahead protocol

Explanation

Question 44 of 50

1

44. The objective of optimization is to minimize the total cost associated with the execution of a request.

Select one of the following:

  • a. data

  • b. remote

  • c. transaction

  • d. query

Explanation

Question 45 of 50

1

is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

Select one of the following:

  • a. Data distribution

  • b. Replica transparency

  • c. Network latency

  • d. Network partitioning

Explanation

Question 46 of 50

1

fragmentation allows a user to break a single object into two or more segments, or fragments.

Select one of the following:

  • a. Horizontal

  • b. Vertical

  • c. Data

  • d. Request

Explanation

Question 47 of 50

1

47. fragmentation refers to the division of a relation into subsets of tuples.

Select one of the following:

  • a. Vertical

  • b. Horizontal

  • c. Data

  • d. Mixed

Explanation

Question 48 of 50

1

fragmentation refers to the division of a relation into attribute subsets.

Select one of the following:

  • a. Data

  • b. Horizontal

  • c. Vertical

  • d. Mixed

Explanation

Question 49 of 50

1

49. The rule requires that all copies of data fragments be identical.

Select one of the following:

  • a. shared fragment

  • b. mutual consistency

  • horizontal fragmentation

  • d. replication

Explanation

Question 50 of 50

1

50. A(n) database stores each database fragment at a single site.

Select one of the following:

  • a. partially replicated

  • b. unreplicated

  • c. fully replicated

  • d. partitioned

Explanation

Previous
Next