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 If both data and database administration exist in an organization, the database administrator is responsible for which of the following? Database design All of these Data modeling Metadata Database design All of these Data modeling Metadata ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is true concerning open-source DBMS? Is competitive against PC-oriented packages and is not fully SQL compliant Is free or nearly free database software whose source code is not publicly available Is free or nearly free database software whose source code is publicly available Is not competitive against PC-oriented packages and is fully SQL compliant Is competitive against PC-oriented packages and is not fully SQL compliant Is free or nearly free database software whose source code is not publicly available Is free or nearly free database software whose source code is publicly available Is not competitive against PC-oriented packages and is fully SQL compliant ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? Resolve data ownership issues Protect the security of the database Establish backup and recovery procedures Tune database performance Resolve data ownership issues Protect the security of the database Establish backup and recovery procedures Tune database performance ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS