Database MCQ - English

Data and Database Administration MCQ Questions and Answers

Home | Database | Data and Database Administration

In this section we provide lots of objective question of Data and Database Administration in Database Management System.

Page: 1/2

1) 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.

Answer : C Discuss

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.

Answer : C Discuss

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.

Answer : B Discuss

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.

Answer : D Discuss

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

Answer : A Discuss

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

Answer : D Discuss

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.

Answer : D Discuss

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

    Delete
    Insert
    Read
    Update

Answer : C Discuss

9) Locking may cause which of the following problems?

    Erroneous updates
    Deadlock
    Versioning
    All of the above.

Answer : B Discuss

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

Answer : D Discuss

Jump to Pages:

1 2

MCQ Category