Data and Database Administration The transaction log includes which of the following? 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 The before-image of a record ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Failure to control confidentiality may lead to loss of competitiveness. True False True False 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 A traditional data administrator performs which of the following roles? Establish backup and recovery procedures Protect the security of the database Resolve data ownership issues Tune database performance Establish backup and recovery procedures Protect the security of the database Resolve data ownership issues Tune database performance ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is true concerning open-source DBMS? 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 competitive against PC-oriented packages and is not fully SQL compliant 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 free or nearly free database software whose source code is publicly available Is competitive against PC-oriented packages and is not fully SQL compliant Is free or nearly free database software whose source code is not publicly available 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 Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS