Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Switch to duplicate database Rollforward Rollback Reprocess transactions TRUE ANSWER : ? YOUR ANSWER : ?
A data warehouse administrator is concerned with which of the following? The typical roles of a data administrator and redesigning existing applications The typical roles of a database administrator and redesigning existing applications The time to make a decision but not the typical roles of a database administrator The time to make a decision and the typical roles of a database administrator TRUE ANSWER : ? YOUR ANSWER : ?
Poor data administration can lead to which of the following? A single definition of the same data entity Familiarity with existing data Missing data elements All of these TRUE ANSWER : ? YOUR ANSWER : ?
Authorization tables contain highly sensitive data and should be protected by stringent security rules. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning open-source DBMS? Is free or nearly free database software whose source code is not publicly available Is not competitive against PC-oriented packages and is fully SQL compliant Is free or nearly free database software whose source code is publicly available Is competitive against PC-oriented packages and is not fully SQL compliant TRUE ANSWER : ? YOUR ANSWER : ?
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. False True TRUE ANSWER : ? YOUR ANSWER : ?
A traditional data administrator performs which of the following roles? Resolve data ownership issues Tune database performance Establish backup and recovery procedures Protect the security of the database TRUE ANSWER : ? YOUR ANSWER : ?
Information repositories are replacing data dictionaries in many organizations. False True TRUE ANSWER : ? YOUR ANSWER : ?
With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users. True False TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is which of the following? Where the before-images are applied to the database Where the after-images are applied to the database Where the after-images and before-images are applied to the database Switching to an existing copy of the database TRUE ANSWER : ? YOUR ANSWER : ?