Data and Database Administration A traditional data administrator performs which of the following roles? Tune database performance 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 ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Incorrect data is easy to detect. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Concurrency control is important for which of the following reasons? To ensure data integrity when updates occur to the database in a multiuser environment To ensure data integrity while reading data occurs to the database in a multiuser environment To ensure data integrity when updates occur to the database in a single-user environment To ensure data integrity while reading data occurs to the database in a single-user environment To ensure data integrity when updates occur to the database in a multiuser environment To ensure data integrity while reading data occurs to the database in a multiuser environment To ensure data integrity when updates occur to the database in a single-user environment To ensure data integrity while reading data occurs to the database in a single-user environment 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 Information repositories are replacing data dictionaries in many organizations. 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