A shared lock allows which of the following types of transactions to occur? Read Update Insert Delete TRUE ANSWER : ? YOUR ANSWER : ?
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. False True TRUE ANSWER : ? YOUR ANSWER : ?
A transaction log shows before and after images of records that have been modified by transactions. False True 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 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 The typical roles of a data administrator and redesigning existing applications TRUE ANSWER : ? YOUR ANSWER : ?
Locking may cause which of the following problems? Erroneous updates Deadlock All of these Versioning TRUE ANSWER : ? YOUR ANSWER : ?
Mirrored databases are almost always provided in high-availability systems. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollback Reprocess transactions Rollforward Switch to duplicate database TRUE ANSWER : ? YOUR ANSWER : ?
The transaction log includes which of the following? The essential data of the record The after-image of a record The before and after-image of a record The before-image of a record TRUE ANSWER : ? YOUR ANSWER : ?
Databases are not the property of a single function or individual within the organization. True False TRUE ANSWER : ? YOUR ANSWER : ?