Data and Database Administration Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Deadlock Versioning All of these Erroneous updates Deadlock Versioning All of these Erroneous updates ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? 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 Authentication policies ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Poor data administration can lead to which of the following? Missing data elements Familiarity with existing data A single definition of the same data entity All of these Missing data elements Familiarity with existing data A single definition of the same data entity All of these ANSWER DOWNLOAD EXAMIANS APP
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 A traditional data administrator performs which of the following roles? Tune database performance Establish backup and recovery procedures Resolve data ownership issues Protect the security of the database Tune database performance Establish backup and recovery procedures Resolve data ownership issues Protect the security of the database ANSWER DOWNLOAD EXAMIANS APP