Data And Database Administration(Engineering > Computer Science And Engineering > Database System ) Questions and Answers

Question 1. Poor data administration can lead to which of the following?
  1.    Missing data elements
  2.    A single definition of the same data entity
  3.    Familiarity with existing data
  4.    All of these
Explanation:-
Answer: Option A. -> Missing data elements
Question 2. A traditional data administrator performs which of the following roles?
  1.    Tune database performance
  2.    Resolve data ownership issues
  3.    Establish backup and recovery procedures
  4.    Protect the security of the database
Explanation:-
Answer: Option B. -> Resolve data ownership issues
Question 3. Backward recovery is which of the following?
  1.    Where the before-images are applied to the database
  2.    Where the after-images and before-images are applied to the database
  3.    Where the after-images are applied to the database
  4.    Switching to an existing copy of the database
Explanation:-
Answer: Option A. -> Where the before-images are applied to the database
Question 4. Which of the following is part of an administrative policy to secure a database?
  1.    Authentication policies
  2.    All of these
  3.    Limiting particular areas within a building to only authorized people
  4.    Ensure appropriate responses rates are in external maintenance agreements
Explanation:-
Answer: Option B. -> All of these
Question 5. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
  1.    All of these
  2.    Database design
  3.    Data modeling
  4.    Metadata
Explanation:-
Answer: Option B. -> Database design
Question 6. The transaction log includes which of the following?
  1.    The before-image of a record
  2.    The essential data of the record
  3.    The before and after-image of a record
  4.    The after-image of a record
Explanation:-
Answer: Option B. -> The essential data of the record
Question 7. Which of the following could cause data to be unavailable?
  1.    All of these
  2.    Planned database maintenance activities
  3.    Data becoming lost or inaccurate
  4.    The database server
Explanation:-
Answer: Option A. -> All of these
Question 8. Locking may cause which of the following problems?
  1.    Versioning
  2.    Erroneous updates
  3.    All of these
  4.    Deadlock
Explanation:-
Answer: Option D. -> Deadlock
Question 9. A shared lock allows which of the following types of transactions to occur?
  1.    Read
  2.    Insert
  3.    Update
  4.    Delete
Explanation:-
Answer: Option A. -> Read
Question 10. Performance analysis and tuning is which of the following?
  1.    Undertaken one time at the time of the implementation of a new application
  2.    Undertaken as an ongoing part of the backup of a database
  3.    Undertaken one time at the time of a DBMS installation
  4.    Undertaken as an ongoing part of managing a database
Explanation:-
Answer: Option D. -> Undertaken as an ongoing part of managing a database
© Lakshya_Education.com, All Right Reserved.
Contact Us services