Data and Database Administration A shared lock allows which of the following types of transactions to occur? Delete Insert Read Update Delete Insert Read Update 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
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 when updates occur 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 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 when updates occur to the database in a single-user environment To ensure data integrity while reading data occurs to the database in a multiuser environment 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? Metadata Data modeling Database design All of these Metadata Data modeling Database design All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following could cause data to be unavailable? 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 Planned database maintenance activities ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Reprocess transactions Rollback Switch to duplicate database Rollforward Reprocess transactions Rollback Switch to duplicate database Rollforward ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS