Data and Database Administration Concurrency control is important for which of the following reasons? 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 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 ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? All of these Limiting particular areas within a building to only authorized people Ensure appropriate responses rates are in external maintenance agreements Authentication policies All of these Limiting particular areas within a building to only authorized people Ensure appropriate responses rates are in external maintenance agreements Authentication policies ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? The after-image of a record The before and after-image of a record The before-image of a record The essential data of the record The after-image of a record The before and after-image of a record The before-image of a record The essential data of the record ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Authorization tables contain highly sensitive data and should be protected by stringent security rules. 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? Rollforward Reprocess transactions Rollback Switch to duplicate database Rollforward Reprocess transactions Rollback Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? 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 Protect the security of the database ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS