Data and Database Administration Poor data administration can lead to which of the following? A single definition of the same data entity Missing data elements Familiarity with existing data All of these A single definition of the same data entity Missing data elements Familiarity with existing data All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A shared lock allows which of the following types of transactions to occur? Delete Read Insert Update Delete Read Insert Update ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The restore/rerun technique involves reprocessing the day's transactions up to the point of failure. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration If both data and database administration exist in an organization, the database administrator is responsible for which of the following? Database design All of these Data modeling Metadata Database design All of these Data modeling Metadata ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A transaction log shows before and after images of records that have been modified by transactions. False True False True 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 Rollback Switch to duplicate database Reprocess transactions Rollforward Rollback Switch to duplicate database Reprocess transactions ANSWER DOWNLOAD EXAMIANS APP