Mirrored databases are almost always provided in high-availability systems. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Switch to duplicate database Rollback Rollforward Reprocess transactions TRUE ANSWER : ? YOUR ANSWER : ?
With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users. False True TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is which of the following? Where the after-images are applied to the database Where the before-images are applied to the database Switching to an existing copy of the database Where the after-images and before-images are applied to the database TRUE ANSWER : ? YOUR ANSWER : ?
Performance analysis and tuning is which of the following? Undertaken one time at the time of the implementation of a new application Undertaken as an ongoing part of the backup of a database Undertaken one time at the time of a DBMS installation Undertaken as an ongoing part of managing a database TRUE ANSWER : ? YOUR ANSWER : ?
Poor data administration can lead to which of the following? Missing data elements Familiarity with existing data All of these A single definition of the same data entity TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a system failure? Switch to duplicate database Rollback Rollforward Reprocess transactions TRUE ANSWER : ? YOUR ANSWER : ?
A shared lock allows which of the following types of transactions to occur? Insert Delete Read Update TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is part of an administrative policy to secure a database? Limiting particular areas within a building to only authorized people Authentication policies Ensure appropriate responses rates are in external maintenance agreements All of these TRUE ANSWER : ? YOUR ANSWER : ?