The transaction log includes which of the following? The before and after-image of a record The after-image of a record The essential data of the record The before-image of a record 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 time to make a decision and the typical roles of a database administrator 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 TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is part of an administrative policy to secure a database? All of these Ensure appropriate responses rates are in external maintenance agreements Authentication policies Limiting particular areas within a building to only authorized people TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollforward Reprocess transactions Rollback Switch to duplicate database 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 : ?
Poor data administration can lead to which of the following? Familiarity with existing data A single definition of the same data entity All of these Missing data elements TRUE ANSWER : ? YOUR ANSWER : ?
The greatest threat to business security is often internal rather than external. False True TRUE ANSWER : ? YOUR ANSWER : ?
Mirrored databases are almost always provided in high-availability systems. False True TRUE ANSWER : ? YOUR ANSWER : ?
If both data and database administration exist in an organization, the database administrator is responsible for which of the following? Metadata Data modeling All of these Database design TRUE ANSWER : ? YOUR ANSWER : ?
Databases are not the property of a single function or individual within the organization. False True TRUE ANSWER : ? YOUR ANSWER : ?