Database MCQ - English

The Database Environment MCQ Questions and Answers

Home | Database | The Database Environment

In this section we provide lots of objective question of The Database Environment in Database Management System.

Page: 1/2

1) A data warehouse uses:

    partial operational data.
    historical operational data.
    future operational data.
    health care data.

Answer : B Discuss

2) Metadata enables database designers and users to do all of the following except:

    sample data.
    understand what data exist.
    what the fine distinctions are between similar data items.
    what the data mean.

Answer : A Discuss

3) Duplicate data often results in loss of data integrity because:

    the data formats may be inconsistent.
    data values may not agree.
    Both A & B.
    Neither A & B.

Answer : C Discuss

4) Legacy data is which of the following?

    Data contained in a newly-installed system
    Data rejected during the installation of a new system
    Data contained in a file system
    Data contained by a system used prior to the installation of a new system

Answer : D Discuss

5) A database management system (DBMS) is a:

    hardware system used to create, maintain, and provide controlled access to a database.
    hardware system used to create, maintain, and provide uncontrolled access to a database.
    software system used to create, maintain, and provide controlled access to a database.
    software system used to create, maintain, and provide uncontrolled access to a database.

Answer : C Discuss

6) A database application can perform which of the following activities?

    Add records
    Read records
    Update records
    All of the above.

Answer : D Discuss

7) An enterprise data model is:

    a graphical model that shows the high-level entities for an organization.
    a graphical model that shows all entities for an organization.
    a non-graphical model that shows the high-level entities for an organization.
    a non-graphical model that shows the all entities for an organization.

Answer : A Discuss

8) A shared database should:

    be accurate and available.
    provide for backup and recovery.
    be secure.
    All of the above.

Answer : D Discuss

9) Data administrators are responsible for:

    physical database design.
    managing technical issues in the database environment.
    overall management of data resources in an organization.
    writing application programs.

Answer : C Discuss

10) Which of the following types of databases are the most common?

    Personal
    Workgroup
    Department
    Enterprise

Answer : C Discuss

Jump to Pages:

1 2

MCQ Category