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 the backup of a database Undertaken one time at the time of a DBMS installation Undertaken as an ongoing part of managing a database Undertaken one time at the time of the implementation of a new application Undertaken as an ongoing part of the backup of a database Undertaken one time at the time of a DBMS installation Undertaken as an ongoing part of managing a database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? Protect the security of the database Resolve data ownership issues Tune database performance Establish backup and recovery procedures Protect the security of the database Resolve data ownership issues Tune database performance Establish backup and recovery procedures ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Incorrect data is easy to detect. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollforward Reprocess transactions Rollback Switch to duplicate database Rollforward Reprocess transactions Rollback Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Failure to control confidentiality may lead to loss of competitiveness. True False True False 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 All of these Familiarity with existing data Missing data elements A single definition of the same data entity All of these Familiarity with existing data Missing data elements ANSWER DOWNLOAD EXAMIANS APP