Data and Database Administration Which of the following is part of an administrative policy to secure a database? 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 Ensure appropriate responses rates are in external maintenance agreements ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following could cause data to be unavailable? Planned database maintenance activities The database server Data becoming lost or inaccurate All of these Planned database maintenance activities The database server Data becoming lost or inaccurate All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. 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 transaction in progress terminates abnormally? Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is true concerning open-source DBMS? Is free or nearly free database software whose source code is publicly available Is free or nearly free database software whose source code is not 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 publicly available Is free or nearly free database software whose source code is not 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 ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? 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 Establish backup and recovery procedures ANSWER DOWNLOAD EXAMIANS APP