Data and Database Administration A traditional data administrator performs which of the following roles? Protect the security of the database 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 ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A shared lock allows which of the following types of transactions to occur? Delete Insert Update Read Delete Insert Update Read 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Switch to duplicate database Reprocess transactions Rollback Rollforward Switch to duplicate database Reprocess transactions Rollback Rollforward ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? Authentication policies Ensure appropriate responses rates are in external maintenance agreements Limiting particular areas within a building to only authorized people All of these Authentication policies Ensure appropriate responses rates are in external maintenance agreements Limiting particular areas within a building to only authorized people All of these ANSWER DOWNLOAD EXAMIANS APP