Exam 12: Distributed Database Management Systems
Exam 1: Database Systems72 Questions
Exam 2: Data Models75 Questions
Exam 3: The Relational Database Model74 Questions
Exam 4: Entity Relationship Ermodeling75 Questions
Exam 5: Advanced Data Modeling83 Questions
Exam 6: Normalization of Database Tables92 Questions
Exam 7: Introduction to Structured Query Language SQL92 Questions
Exam 8: Advanced SQL95 Questions
Exam 9: Database Design87 Questions
Exam 10: Transaction Management and Concurrency Control76 Questions
Exam 11: Database Performance Tuning and Query Optimization82 Questions
Exam 12: Distributed Database Management Systems72 Questions
Exam 13: Business Intelligence and Data Warehouses75 Questions
Exam 14: Big Data Analytics and NoSQL76 Questions
Exam 15: Database Connectivity and Web Technologies81 Questions
Exam 16: Database Administration and Security81 Questions
Select questions type
Typically,the scenario requires a network file server running conventional applications that are accessed through a network.
(Essay)
4.9/5
(27)
The fragment condition indicates that no row has a duplicate,regardless of the fragment in which it is located.
(Short Answer)
4.9/5
(36)
The transaction processor (TP)is the software component found in each computer that requests data.
(True/False)
4.8/5
(23)
The forces the log entry to be written to permanent storage before the actual operation takes place.
(Short Answer)
4.9/5
(30)
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.
(Multiple Choice)
4.8/5
(33)
Explain the difference between homogeneous and heterogeneous distributed database management systems (DDBMS).
(Essay)
4.9/5
(30)
In a distributed database management system (DDBMS),query is used to find the best access strategy.
(Short Answer)
4.8/5
(31)
A transaction processor (TP)is the software component residing on each computer that stores and retrieves data located at the site.
(True/False)
4.9/5
(38)
The level of transparency supported by the distributed database management system remains the same for all systems.
(True/False)
4.8/5
(44)
The distributed database system must be of the computer hardware system.
(Short Answer)
4.9/5
(39)
A disadvantage of a distributed database management system (DDBMS)is that:
(Multiple Choice)
4.7/5
(37)
One of the advantages of a distributed database management system (DDBMS)is processor .
(Short Answer)
4.8/5
(32)
A distributed database is composed of several parts known as database .
(Multiple Choice)
4.8/5
(36)
Describe any five of the 12 commandments formulated by C.J.Date for distributed databases.
(Essay)
4.7/5
(37)
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.
(Multiple Choice)
5.0/5
(37)
A(n)database stores each database fragment at a single site.
(Multiple Choice)
4.9/5
(34)
Distributed data access was needed to support geographically dispersed business units.
(True/False)
4.9/5
(33)
Showing 41 - 60 of 72
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)