Concurrency control is important for which of the following reasons? To ensure data integrity when updates occur to the database in a multiuser environment To ensure data integrity when updates occur to the database in a single-user environment To ensure data integrity while reading data occurs to the database in a single-user environment To ensure data integrity while reading data occurs to the database in a multiuser environment TRUE ANSWER : ? YOUR ANSWER : ?
Information repositories are replacing data dictionaries in many organizations. True False TRUE ANSWER : ? YOUR ANSWER : ?
A traditional data administrator performs which of the following roles? Establish backup and recovery procedures Resolve data ownership issues Protect the security of the database Tune database performance 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 All of these Ensure appropriate responses rates are in external maintenance agreements Authentication policies TRUE ANSWER : ? YOUR ANSWER : ?
A data warehouse administrator is concerned with which of the following? The time to make a decision and the typical roles of a database administrator The typical roles of a data administrator and redesigning existing applications The time to make a decision but not the typical roles of a database administrator The typical roles of a database administrator and redesigning existing applications TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is which of the following? Switching to an existing copy of the database Where the after-images are applied to the database Where the before-images are applied to the database Where the after-images and before-images are applied to the database TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally. False True TRUE ANSWER : ? YOUR ANSWER : ?
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. True False TRUE ANSWER : ? YOUR ANSWER : ?
Mirrored databases are almost always provided in high-availability systems. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following could cause data to be unavailable? The database server Planned database maintenance activities Data becoming lost or inaccurate All of these TRUE ANSWER : ? YOUR ANSWER : ?