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 Backward recovery is which of the following? Switching to an existing copy of the database Where the before-images are applied to the database Where the after-images are applied to the database Where the after-images and before-images are applied to the database Switching to an existing copy of the database Where the before-images are applied to the database Where the after-images are applied to the database Where the after-images and before-images are applied to the database ANSWER DOWNLOAD EXAMIANS APP
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 A shared lock allows which of the following types of transactions to occur? Read Insert Delete Update Read Insert Delete Update ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following could cause data to be unavailable? Planned database maintenance activities All of these Data becoming lost or inaccurate The database server Planned database maintenance activities All of these Data becoming lost or inaccurate The database server ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Authorization tables contain highly sensitive data and should be protected by stringent security rules. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS