Data and Database Administration Poor data administration can lead to which of the following? 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 A single definition of the same data entity ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? Limiting particular areas within a building to only authorized people Authentication policies All of these Ensure appropriate responses rates are in external maintenance agreements Limiting particular areas within a building to only authorized people Authentication policies All of these Ensure appropriate responses rates are in external maintenance agreements ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Erroneous updates All of these Deadlock Versioning Erroneous updates All of these Deadlock Versioning ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A transaction log shows before and after images of records that have been modified by transactions. 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 Switch to duplicate database Rollback Rollforward Reprocess transactions Switch to duplicate database Rollback 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? All of these Database design Metadata Data modeling All of these Database design Metadata Data modeling ANSWER DOWNLOAD EXAMIANS APP