Question 1

A user-friendly _____ is one advantage of a distributed database management system (DDBMS) .

Accepted Answer

The answer of A user-friendly _____ is one advantage of...

Question 2

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.
A) Horizontal
B) Vertical
C) Data
D) Request

Accepted Answer

Data fragmentation is the process of breaking a single object into two or more segments, or fragments. This is often used in computer networks to transmit data more efficiently and quickly. Horizontal fragmentation refers to breaking up data by columns, while vertical fragmentation refers to breaking up data by rows. Request fragmentation is not a commonly used term in computing.

Question 3

A transaction processor is also known as the _____ processor.

Accepted Answer

The answer of A transaction processor is also known as...

Question 4

The _____ rule requires that all copies of data fragments be identical.
A) shared fragment
B) mutual consistency
C) horizontal fragmentation
D) replication

Accepted Answer

The answer of The _____ rule requires that all copies...

Question 5

In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.

Accepted Answer

The answer of In a distributed database management system (DDBMS),...

Question 6

One of the advantages of a distributed database management system (DDBMS) is processor _____.

Accepted Answer

The answer of One of the advantages of a distributed...

Question 7

_____ fragmentation refers to the division of a relation into subsets of tuples.
A) Vertical
B) Horizontal
C) Data
D) Mixed

Accepted Answer

Horizontal fragmentation refers to the division of a relation into subsets of tuples based on some criteria such as a range of values, a specific attribute, or a condition. This can be useful for distributing data across multiple nodes in a distributed database system. Vertical fragmentation, on the other hand, involves dividing a relation into subsets of attributes, and is often used for reducing redundancy and improving query performance. Data fragmentation refers to the splitting of data across multiple locations or types of storage media. Mixed fragmentation combines elements of both horizontal and vertical fragmentation.

Question 8

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.

Accepted Answer

The answer of In a distributed database management system (DDBMS),...

Question 9

_____ management ensures that data move from one consistent state to another.

Accepted Answer

The answer of _____ management ensures that data move from...

Question 10

In a distributed database management system (DDBMS), query _____ is used to find the best access strategy.

Accepted Answer

The answer of In a distributed database management system (DDBMS),...

Question 11

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.
A) DO-UNDO-REDO protocol
B) two-phase commit protocol (2PC)
C) coordinator protocol
D) write-ahead protocol

Accepted Answer

The two-phase commit protocol (2PC) ensures that either all sites participating in a transaction commit or all sites abort. This ensures that the database remains in a consistent state even if a site fails to commit. The DO-UNDO-REDO protocol and write-ahead protocol are techniques used to ensure recoverability of committed transactions, but they do not address the issue of distributed transactions. The coordinator protocol is a vague term and does not refer to a specific protocol used in distributed transactions.

Question 12

A(n) _____ database stores each database fragment at a single site.
A) partially replicated
B) unreplicated
C) fully replicated
D) partitioned

Accepted Answer

An unreplicated database stores each database fragment at a single site. It means that each site is responsible for its own data and there is no duplication of data across multiple sites. This approach is useful when the amount of data is small or when each site has a unique set of data that needs to be accessed separately.

Question 13

Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?
A) Consistency
B) Partition tolerance
C) Availability
D) Performance transparency

Accepted Answer

The consistency property of CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database. This means that when a transaction is committed, all nodes in the distributed system should reflect the same data. Therefore, the correct answer is A) Consistency.

Question 14

The objective of _____ optimization is to minimize the total cost associated with the execution of a request.
A) data
B) remote
C) transaction
D) query

Accepted Answer

The objective of query optimization is to minimize the total cost associated with the execution of a request, focusing on efficiently retrieving data from a database.

Question 15

One of the advantages of a distributed database management system (DDBMS) is _____ operating cost.

Accepted Answer

The answer of One of the advantages of a distributed...

Question 16

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.
A) mixed
B) replicated
C) centralized
D) partitioned

Accepted Answer

During partitioned data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

Question 17

_____ fragmentation refers to the division of a relation into attribute subsets.
A) Data
B) Horizontal
C) Vertical
D) Mixed

Accepted Answer

Vertical fragmentation refers to dividing a relation into vertical subsets, where each subset contains specific attributes or columns. This fragmentation can be useful in situations where different subsets of data are needed or used by different applications. Horizontal fragmentation refers to dividing a relation into horizontal subsets, where each subset contains specific rows of data. Data fragmentation is a more general term encompassing both vertical and horizontal fragmentation. Mixed fragmentation involves using both vertical and horizontal fragmentation techniques to divide a relation. However, none of the choices accurately describe "attribute subsets" except for C) Vertical fragmentation.

Question 18

One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.

Accepted Answer

The answer of One of the advantages of a distributed...

Question 19

_____ 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.
A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning

Accepted Answer

Network latency is the delay caused by the amount of time it takes for a data packet to travel from point A to point B and back again. It is also known as round trip time (RTT).

Question 20

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.

Accepted Answer

The answer of In a basic distributed processing environment, the...

Quiz 12: Distributed Database Management Systems

A user-friendly _____ is one advantage of a distributed database management system (DDBMS) .

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

A transaction processor is also known as the _____ processor.

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

In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.

One of the advantages of a distributed database management system (DDBMS) is processor _____.

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

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.

_____ management ensures that data move from one consistent state to another.

In a distributed database management system (DDBMS), query _____ is used to find the best access strategy.

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.

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

Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?

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

One of the advantages of a distributed database management system (DDBMS) is _____ operating cost.

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

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

One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.

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

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.