Data and Database Administration Mirrored databases are almost always provided in high-availability systems. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Performance analysis and tuning is which of the following? Undertaken one time at the time of the implementation of a new application Undertaken as an ongoing part of managing a database Undertaken as an ongoing part of the backup of a database Undertaken one time at the time of a DBMS installation Undertaken one time at the time of the implementation of a new application Undertaken as an ongoing part of managing a database Undertaken as an ongoing part of the backup of a database Undertaken one time at the time of a DBMS installation ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Poor data administration can lead to which of the following? A single definition of the same data entity Familiarity with existing data All of these Missing data elements A single definition of the same data entity Familiarity with existing data All of these Missing data elements ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following is part of an administrative policy to secure a database? Authentication policies Ensure appropriate responses rates are in external maintenance agreements Limiting particular areas within a building to only authorized people All of these Authentication policies Ensure appropriate responses rates are in external maintenance agreements Limiting particular areas within a building to only authorized people All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS