Data and Database Administration MCQs

Question 1

Poor data administration can lead to which of the following?

Accepted Answer

Missing data elements

Answer

A single definition of the same data entity

Answer

Familiarity with existing data

Answer

All of the above

Question 2

A traditional data administrator performs which of the following roles?

Accepted Answer

Resolve data ownership issues

Answer

Tune database performance

Answer

Establish backup and recovery procedures

Answer

Protect the security of the database

Question 3

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

Accepted Answer

Database design

Answer

Data modeling

Answer

Metadata

Answer

All of the above

Question 4

Which of the following is part of an administrative policy to secure a database?

Accepted Answer

All of the above

Answer

Authentication policies

Answer

Limiting particular areas within a building to only authorized people

Answer

Ensure appropriate responses rates are in external maintenance agreements

Question 5

Backward recovery is which of the following?

Accepted Answer

Where the before-images are applied to the database

Answer

Where the after-images are applied to the database

Answer

Where the after-images and before-images are applied to the database

Answer

Switching to an existing copy of the database

Question 6

The transaction log includes which of the following?

Accepted Answer

The essential data of the record

Answer

The before-image of a record

Answer

The after-image of a record

Answer

The before and after-image of a record

Question 7

Which of the following could cause data to be unavailable?

Accepted Answer

All of the above

Answer

Data becoming lost or inaccurate

Answer

The database server

Answer

Planned database maintenance activities

Question 8

A shared lock allows which of the following types of transactions to occur?

Accepted Answer

Read

Answer

Delete

Answer

Insert

Answer

Update

Question 9

Locking may cause which of the following problems?

Accepted Answer

Deadlock

Answer

Erroneous updates

Answer

Versioning

Answer

All of the above