Data and Database Administration A traditional data administrator performs which of the following roles? Establish backup and recovery procedures Resolve data ownership issues Protect the security of the database Tune database performance Establish backup and recovery procedures Resolve data ownership issues Protect the security of the database Tune database performance ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Versioning Erroneous updates All of these Deadlock Versioning Erroneous updates All of these Deadlock ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Queries that do full table scans should be avoided. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Data modeling and database design are key responsibilities of data and data base administration. 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? Rollback Switch to duplicate database Rollforward Reprocess transactions Rollback Switch to duplicate database Rollforward Reprocess transactions ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? The essential data of the record The before-image of a record The after-image of a record The before and after-image of a record The essential data of the record The before-image of a record The after-image of a record The before and after-image of a record ANSWER DOWNLOAD EXAMIANS APP