Data and Database Administration Queries that do full table scans should be avoided. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Versioning Erroneous updates Deadlock All of these Versioning Erroneous updates Deadlock All of these 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? Data modeling Metadata Database design All of these Data modeling Metadata Database design All of these 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 shared lock allows which of the following types of transactions to occur? Update Insert Delete Read Update Insert Delete Read 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