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 Rollforward Reprocess transactions Switch to duplicate database Rollback Rollforward Reprocess transactions ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Mirrored databases are almost always provided in high-availability systems. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? The before-image of a record The essential data of the record The before and after-image of a record The after-image of a record The before-image of a record The essential data of the record The before and after-image of a record The after-image of a record ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. True False True False 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 competitive against PC-oriented packages and is not fully SQL compliant Is not competitive against PC-oriented packages and is 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 competitive against PC-oriented packages and is not fully SQL compliant 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? Protect the security of the database Establish backup and recovery procedures Resolve data ownership issues Tune database performance Protect the security of the database Establish backup and recovery procedures Resolve data ownership issues Tune database performance ANSWER DOWNLOAD EXAMIANS APP