Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Rollforward Reprocess transactions Rollback Switch to duplicate database Rollforward Reprocess transactions Rollback Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Versioning Erroneous updates Deadlock All of these Versioning Erroneous updates Deadlock All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Mirrored databases are almost always provided in high-availability systems. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration 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 A single definition of the same data entity Familiarity with existing data Missing data elements All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration 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 The database server Planned database maintenance activities Data becoming lost or inaccurate All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? Establish backup and recovery procedures Tune database performance Protect the security of the database Resolve data ownership issues Establish backup and recovery procedures Tune database performance Protect the security of the database Resolve data ownership issues ANSWER DOWNLOAD EXAMIANS APP