The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. False True TRUE ANSWER : ? YOUR ANSWER : ?
Poor data administration can lead to which of the following? A single definition of the same data entity All of these Familiarity with existing data Missing data elements TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following could cause data to be unavailable? Planned database maintenance activities All of these The database server Data becoming lost or inaccurate TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a system failure? Reprocess transactions Switch to duplicate database Rollforward Rollback TRUE ANSWER : ? YOUR ANSWER : ?
A traditional data administrator performs which of the following roles? Resolve data ownership issues Establish backup and recovery procedures Protect the security of the database Tune database performance TRUE ANSWER : ? YOUR ANSWER : ?
Locking may cause which of the following problems? All of these Erroneous updates Deadlock Versioning TRUE ANSWER : ? YOUR ANSWER : ?
The greatest threat to business security is often internal rather than external. False True TRUE ANSWER : ? YOUR ANSWER : ?
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 : ?
A shared lock allows which of the following types of transactions to occur? Insert Update Read Delete TRUE ANSWER : ? YOUR ANSWER : ?