Database - Data and Database Administration

Database - Data and Database Administration
1. Database- 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
  • Missing data elements
  • All of the above.
Show Answer
2. 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.
Show Answer
3. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
  • Data modeling
  • Database design
  • Metadata
  • All of the above.
Show Answer
4. Which of the following is part of an administrative policy to secure a database?
  • Authentication policies
  • Limiting particular areas within a building to only authorized people
  • Ensure appropriate responses rates are in external maintenance agreements
  • All of the above.
Show Answer
5. Backward recovery is which of the following?
  • Where the before-images are applied to the database
  • Where the after-images are applied to the database
  • Where the after-images and before-images are applied to the database
  • Switching to an existing copy of the database
Show Answer
6. The transaction log includes which of the following?
  • The before-image of a record
  • The after-image of a record
  • The before and after-image of a record
  • The essential data of the record
Show Answer
7. Which of the following could cause data to be unavailable?
  • Data becoming lost or inaccurate
  • The database server
  • Planned database maintenance activities
  • All of the above.
Show Answer
8. A shared lock allows which of the following types of transactions to occur?
  • Delete
  • Insert
  • Read
  • Update
Show Answer
9. Locking may cause which of the following problems?
  • Erroneous updates
  • Deadlock
  • Versioning
  • All of the above.
Show Answer
10. Performance analysis and tuning is which of the following?
  • 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 the backup of a database
  • Undertaken as an ongoing part of managing a database
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test