Data and Database Administration A traditional data administrator performs which of the following roles? 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 Tune database performance 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? All of these Data modeling Database design Metadata All of these Data modeling Database design Metadata ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following could cause data to be unavailable? All of these 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 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? Reprocess transactions Rollforward Rollback Switch to duplicate database Reprocess transactions Rollforward Rollback Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A shared lock allows which of the following types of transactions to occur? Update Delete Insert Read Update Delete Insert Read ANSWER DOWNLOAD EXAMIANS APP