Data and Database Administration The transaction log includes which of the following? The before-image of a record The after-image of a record The essential data of the record The before and after-image of a record The before-image of a record The after-image of a record The essential data of the record The before and after-image of a record 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 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 If both data and database administration exist in an organization, the database administrator is responsible for which of the following? Data modeling Database design All of these Metadata Data modeling Database design All of these Metadata ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? Limiting particular areas within a building to only authorized people Ensure appropriate responses rates are in external maintenance agreements Authentication policies All of these Limiting particular areas within a building to only authorized people Ensure appropriate responses rates are in external maintenance agreements Authentication policies 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 Resolve data ownership issues Tune database performance Protect the security of the database Establish backup and recovery procedures Resolve data ownership issues Tune database performance Protect the security of the database ANSWER DOWNLOAD EXAMIANS APP