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 Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally. 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 while reading data occurs to the database in a single-user 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 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 while reading data occurs to the database in a multiuser environment To ensure data integrity when updates occur 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 The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? The before and after-image of a record The before-image of a record The after-image of a record The essential data of the record The before and after-image of a record The before-image of a record The after-image of a record The essential data of the record 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
EXAMIANS