8457318
Beschreibung
Quiz von Miguel Lucero, aktualisiert more than 1 year ago
|
Erstellt von Miguel Lucero
vor mehr als 7 Jahre
|
|
Frage 1
Frage
1. A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.
Antworten
- True
- False
Frage 2
Frage
2. Distributed data access was needed to support geographically dispersed business units.
Antworten
- True
- False
Frage 3
Frage
3. Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
Antworten
- True
- False
Frage 4
Frage
4. The Internet is the repository for distributed data.
Antworten
- True
- False
Frage 5
Frage
5. Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control
Antworten
- True
- False
Frage 6
Frage
6. Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.
Antworten
- True
- False
Frage 7
Frage
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.
Antworten
- True
- False
Frage 8
Frage
8. One of the advantages of a distributed database management system (DDBMS) is growth facilitation.
Antworten
- True
- False
Frage 9
Frage
9. One of the advantages of a distributed database management system (DDBMS) is security.
Antworten
- True
- False
Frage 10
Frage
10. Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
Antworten
- True
- False
Frage 11
Frage
11. In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
Antworten
- True
- False
Frage 12
Frage
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.
Antworten
- True
- False
Frage 13
Frage
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.
Antworten
- True
- False
Frage 14
Frage
14. The transaction processor (TP) is the software component found in each computer that requests data.
Antworten
- True
- False
Frage 15
Frage
15. A distributed database management system (DDBMS) must be communications-media-dependent.
Antworten
- True
- False
Frage 16
Frage
16. A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site.
Antworten
- True
- False
Frage 17
Frage
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.
Antworten
- True
- False
Frage 18
Frage
18. Performance transparency ensures that the system finds the most cost-effective path to access remote data.
Antworten
- True
- False
Frage 19
Frage
The level of transparency supported by the distributed database management system remains the same for all systems.
Antworten
- True
- False
Frage 20
Frage
20. Distribution transparency is supported by a distributed data dictionary.
Antworten
- True
- False
Frage 21
Frage
21. Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
Antworten
- True
- False
Frage 22
Frage
22. A remote transaction, composed of several requests, may access data at multiple sites.
Antworten
- True
- False
Frage 23
Frage
23. A centralized database management is subject to a problem such as____________
Antworten
-
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
Frage 24
Frage
24. A disadvantage of a distributed database management system (DDBMS) is that:
Antworten
-
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.
Frage 25
Frage
25. A distributed database is composed of several parts known as database .
Antworten
-
a. sections
-
b. fragments
-
c. partitions
-
d. parts
Frage 26
Frage
26. Distributed processing does not require
Antworten
-
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.
Frage 27
Frage
27. A database management system needs to prepare the data for presentation to the end user or to an application program.
Antworten
-
a. security
-
b. concurrency control
-
c. formatting
-
d. I/O interface
Frage 28
Frage
28. The processor is the software component found in each computer that requests data. It receives and processes the application's data requests.
Antworten
-
a. database
-
b. transaction
-
c. data
-
d. network
Frage 29
Frage
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.
Antworten
-
a. transaction processor
-
b. application processor
-
c. transaction manager
-
d. data processor
Frage 30
Frage
30. Under the scenario, all record- and file-locking activities are performed at the end-user location.
Antworten
-
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
Frage 31
Frage
31. _____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.
Antworten
-
a. Homogeneous
-
b. Heterogeneous
-
c. Fully heterogeneous
-
d. Combination
Frage 32
Frage
32. A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
Antworten
-
a. fully heterogeneous
-
b. fully homogeneous
-
c. homogeneous
-
d. heterogeneous
Frage 33
Frage
33. A DDBMS is subject to which of the following restrictions?
Antworten
-
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.
Frage 34
Frage
34. transparency allows a physically dispersed database to be managed as though it were centralized.
Antworten
-
a. Distribution
-
b. Transaction
-
c. Failure
-
d. Performance
Frage 35
Frage
35. transparency allows data to be updated simultaneously at several network sites.
Antworten
-
a. Transaction
-
b. Distribution
-
c. Failure
-
d. Performance
Frage 36
Frage
36. transparency allows the system to operate as if it were a centralized database management system.
Antworten
-
a. Heterogeneity
-
b. Distribution
-
c. Performance
-
d. Failure
Frage 37
Frage
transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.
Antworten
-
a. Performance
-
b. Fragmentation
-
c. Location
-
d. Local mapping
Frage 38
Frage
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.
Antworten
-
a. Transaction
-
b. Location
-
c. Local mapping
-
d. Fragmentation
Frage 39
Frage
39. A contains the description of the entire database as seen by the database administrator.
Antworten
-
a. distributed global dictionary
-
b. distributed data dictionary
-
c. distributed global schema
-
d. distributed data schema
Frage 40
Frage
40. A lets a single SQL statement access the data that are to be processed by a single remote database processor.
Antworten
-
a. remote request
-
b. remote transaction
-
c. distributed request
-
d. distributed transaction
Frage 41
Frage
41. A distributed can reference several different local or remote data processing sites.
Antworten
-
a. request
-
b. site
-
c. data location
-
d. transaction
Frage 42
Frage
42. A request lets a single SQL statement reference data located at several different local or remote DP sites.
Antworten
-
a. distributed
-
b. transaction
-
c. fragmented
-
d. remote
Frage 43
Frage
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.
Antworten
-
a. DO-UNDO-REDO protocol
-
b. two-phase commit protocol (2PC)
-
c. coordinator protocol
-
d. write-ahead protocol
Frage 44
Frage
44. The objective of optimization is to minimize the total cost associated with the execution of a request.
Antworten
-
a. data
-
b. remote
-
c. transaction
-
d. query
Frage 45
Frage
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.
Antworten
-
a. Data distribution
-
b. Replica transparency
-
c. Network latency
-
d. Network partitioning
Frage 46
Frage
fragmentation allows a user to break a single object into two or more segments, or fragments.
Antworten
-
a. Horizontal
-
b. Vertical
-
c. Data
-
d. Request
Frage 47
Frage
47. fragmentation refers to the division of a relation into subsets of tuples.
Antworten
-
a. Vertical
-
b. Horizontal
-
c. Data
-
d. Mixed
Frage 48
Frage
fragmentation refers to the division of a relation into attribute subsets.
Antworten
-
a. Data
-
b. Horizontal
-
c. Vertical
-
d. Mixed
Frage 49
Frage
49. The rule requires that all copies of data fragments be identical.
Antworten
-
a. shared fragment
-
b. mutual consistency
-
horizontal fragmentation
-
d. replication
Frage 50
Frage
50. A(n) database stores each database fragment at a single site.
Antworten
-
a. partially replicated
-
b. unreplicated
-
c. fully replicated
-
d. partitioned
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.