Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Rollforward Switch to duplicate database Reprocess transactions Rollback Rollforward Switch to duplicate database Reprocess transactions Rollback ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollforward Rollback Reprocess transactions Switch to duplicate database Rollforward Rollback Reprocess transactions Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? Ensure appropriate responses rates are in external maintenance agreements All of these Limiting particular areas within a building to only authorized people Authentication policies Ensure appropriate responses rates are in external maintenance agreements All of these Limiting particular areas within a building to only authorized people Authentication policies ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A transaction log shows before and after images of records that have been modified by transactions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A disaster recovery plan does not need to include the shipment of database backups to other sites. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration If both data and database administration exist in an organization, the database administrator is responsible for which of the following? Data modeling All of these Database design Metadata Data modeling All of these Database design Metadata ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS