Question 1

Which of the following is an advantage to data replication?
A) Reliability
B) Fast response
C) Node decoupling
D) All of the above

Accepted Answer

Data replication provides reliability by storing multiple copies of data, ensuring that if one copy is lost or corrupted, there are still other copies available. It also allows for faster response times as data can be accessed from multiple locations. Additionally, node decoupling is possible with data replication, which means that each node can operate independently without relying on other nodes for information. Therefore, all of the above are advantages of data replication.

Question 2

Which of the following characterizes homogeneous environments?
A) Contains simple pathways
B) Same DBMS used at all locations
C) Some users require only local access
D) Cross-linked systems easily communicate

Accepted Answer

Homogeneous environments are characterized by the use of the same DBMS at all locations.

Question 3

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?
A) Centralized; maximum
B) Centralized; minimum
C) Homogeneous; nonautonomous
D) Federated; nonautonomous

Accepted Answer

C

Question 4

________ is a design goal for a distributed database,which says a user does not need to know the location of data to use the data.
A) Location transparency
B) Location autonomy
C) Location dependency
D) Distributed locatability

Accepted Answer

Location transparency is the design goal that allows users to use data without needing to know its location. This means that the database system should take care of locating the required data and routing the request to the appropriate server in the network. The other options (B, C, D) do not accurately describe this design goal.

Question 5

Which of the following environments uses a different DBMS at each node,and supports local databases for unique data requests?
A) Gateways; local
B) Centralized; minimum
C) Homogeneous; cross-linked
D) Heterogeneous; federated

Accepted Answer

Heterogeneous environments use a different DBMS at each node and support local databases for unique data requests, and federated environments ensure that data is seamless and transparently accessible to applications and users, regardless of where the data is stored or how it is managed.

Question 6

One way to generate store and forward messages for completed transactions to be broadcast across a network is through the use of:
A) stored procedures.
B) triggers.
C) functions.
D) SQL statements.

Accepted Answer

The answer of One way to generate store and forward...

Question 7

An integrated partition strategy is ________ to manage.
A) excellent
B) difficult
C) easy
D) medium

Accepted Answer

The answer of An integrated partition strategy is ________ to...

Question 8

Which of the following are business conditions that encourage the use of distributed databases?
A) Business unit autonomy
B) Data sharing needs
C) Data communication reliability
D) All of the above

Accepted Answer

Distributed databases are most useful in business conditions that require business unit autonomy, data sharing needs, and reliable data communication. These conditions can be met by using distributed databases that allow business units to access and manage their own information while still ensuring that the data is shared across the entire organization. Additionally, distributed databases can provide greater data communication reliability by distributing data across multiple locations, reducing the risk of system failure or data loss. Therefore, all of the above business conditions encourage the use of distributed databases.

Question 9

All of the following are advantages of vertical partitioning EXCEPT:
A) efficiency.
B) security.
C) ease of querying.
D) easier to set up than horizontal partitioning.

Accepted Answer

This is the only option that is not an advantage of vertical partitioning. Vertical partitioning can increase efficiency by reducing the amount of data that needs to be accessed for a specific query, provide better security by limiting access to certain columns of data, and make querying easier by dividing the data into smaller, more manageable chunks. However, setting up vertical partitioning may require more planning and design compared to horizontal partitioning, which can be more straightforward.

Question 10

Which of the following is true about horizontal partitioning?
A) Data can be stored to optimize local access.
B) Data are less secure.
C) There is consistent access speed.
D) None of the above

Accepted Answer

Horizontal partitioning is a database sharding technique that involves splitting a database into multiple smaller sub-databases or partitions, and each partition stores a subset of the data. This allows data to be stored closer to where it is being accessed, optimizing local access. However, it can also result in less secure data if not properly managed. Consistent access speed may not always be guaranteed as it depends on how the data is partitioned and accessed.

Question 11

Which of the following supports a simple path to other databases,without the benefits of one logical database?
A) Linked; differential
B) Gateways
C) Autonomous; cross-linked
D) Federated; nonautonomous

Accepted Answer

Gateways allow for a simple path to other databases without the benefits of one logical database. They act as a bridge between different databases and offer a way for applications to access data from multiple sources without having to know the details of each individual database. The other options mentioned (A, C, and D) refer to different types of database architectures that do not necessarily support a simple path to other databases.

Question 12

All of the following are disadvantages of data replication EXCEPT:
A) storage requirements.
B) reduced network traffic at prime time.
C) complexity and cost of updating.
D) none of the above.

Accepted Answer

Reduced network traffic at prime time is actually an advantage of data replication, as it allows for more efficient data access and reduces network congestion during peak usage. The other options listed are all disadvantages of data replication, including increased storage requirements, complexity and cost of updating multiple copies of the same data, and potential inconsistencies between different replicas of the same data.

Question 13

Snapshot replication is most appropriate for:
A) a data warehouse application.
B) an application where the processing of data follows a workflow across the business units.
C) a transaction processing system.
D) none of the above.

Accepted Answer

Snapshot replication works best for applications like data warehouses, where the data is static and doesn't change frequently. It involves taking regular snapshots of the data and replicating it to other servers, keeping them in sync. It is not suitable for transaction processing systems, where the data is highly dynamic and constantly changing. It is also not ideal for applications where data processing follows a workflow across business units, as changes to the data during the workflow may be missed.

Question 14

A synchronized replication strategy has a(n)________ reliability.
A) excellent
B) good
C) fair
D) medium

Accepted Answer

A synchronized replication strategy ensures that all replicas are updated simultaneously, reducing the risk of data inconsistencies and failures. This leads to excellent reliability compared to other replication strategies.

Question 15

Replication should be used when:
A) data currency and timing doesn't matter.
B) there is a highly heterogeneous network.
C) when there are no or few triggers.
D) all of the above.

Accepted Answer

The answer of Replication should be used when:
A) data currency...

Question 16

Which of the following is true of data replication?
A) Additional storage requirements
B) Faster response
C) Node decoupling
D) All of the above

Accepted Answer

All of the given options are true for data replication. Additional storage is required to store multiple copies of data, but it enables faster response time by providing multiple sources of the same data. Replication also allows for node decoupling, which means nodes can operate independently without relying on a single source for data.

Question 17

With a pull strategy of replication,the ________ node determines when a database is updated.
A) user
B) source
C) target
D) all of the above

Accepted Answer

In a pull strategy of replication, the target node initiates the update process by requesting data from the source node.

Question 18

Which of the following is true of distributed databases?
A) Less reliable
B) Better local control
C) Slower response time
D) None of the above

Accepted Answer

Distributed databases offer better local control as data is stored closer to where it is needed, allowing for more efficient management and access.

Question 19

A(n)________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.
A) distributed database
B) decentralized database
C) unlinked database
D) data repository

Accepted Answer

The answer of A(n)________ is a database stored on multiple...

Question 20

A centralized strategy has ________ expandability.
A) excellent
B) good
C) poor
D) medium

Accepted Answer

A centralized strategy has poor expandability because it relies on a single point of control and decision-making, which limits the ability to scale and adapt to changing circumstances. Decisions and actions must go through the centralized point, leading to potential bottlenecks and delays. In contrast, a decentralized strategy allows for more flexibility and distributed decision-making, which promotes more efficient expansion.

Quiz 12: Distributed Databases

Which of the following is an advantage to data replication?

Which of the following characterizes homogeneous environments?

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?

________ is a design goal for a distributed database,which says a user does not need to know the location of data to use the data.

Which of the following environments uses a different DBMS at each node,and supports local databases for unique data requests?

One way to generate store and forward messages for completed transactions to be broadcast across a network is through the use of:

An integrated partition strategy is ________ to manage.

Which of the following are business conditions that encourage the use of distributed databases?

All of the following are advantages of vertical partitioning EXCEPT:

Which of the following is true about horizontal partitioning?

Which of the following supports a simple path to other databases,without the benefits of one logical database?

All of the following are disadvantages of data replication EXCEPT:

Snapshot replication is most appropriate for:

A synchronized replication strategy has a(n) ________ reliability.

Replication should be used when:

Which of the following is true of data replication?

With a pull strategy of replication,the ________ node determines when a database is updated.

Which of the following is true of distributed databases?

A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.

A centralized strategy has ________ expandability.