Databases Reference
In-Depth Information
5.
Which of the following statements correctly describe running multiple
database server instances on a single computer?
(a)
It provides a way to minimize hardware costs, assuming the server
has sufficient resources to support the instances.
(b)
Each server instance is configured and managed separately from the
other server instances.
(c)
The configuration should be used in a development environment
rather than a production environment.
(d)
all of the above
6.
Which of the following is an advantage of a distributed database configu-
ration in which a full copy of the database is maintained at each location?
(a)
Communication requirements are minimized.
(b)
There is no need to replicate changes between locations.
(c)
There is no possibility of concurrency errors between locations.
(d)
Disk space requirements are minimized.
7.
To help ensure data integrity and minimize concurrency problems,
distributed transactions are managed using a three-phase commit process.
True or false?
8.
You are designing an application that uses a distributed data environment.
You want to minimize communication and disk storage requirements at
each location. The solution should minimize the possibility of data
consistency errors when updates are made at remote locations. Which
configuration best suites your needs?
(a)
Put a full copy of the entire database at each location.
(b)
Put a copy of the database with all data tables at each location. Horizon-
tally partition the tables to filter out rows not applicable to that location.
(c)
Put a full copy of only the most frequently accessed table at each
location.
(d)
Put a horizontally partitioned copy of the most frequently accessed
table at each location.
9.
Which replication type overwrites the complete destination table?
(a)
snapshot replication
(b)
merge replication
(c)
change replication
(d)
transactional replication
10.
Which replication configuration has the highest risk of conflict?
(a)
Allow updates at a master copy of the database only.
(b)
Allow updates at the remote data copies, consolidate the changes at
the master copy, and distribute the changes.
