Menu
Home / CSE / Database System 2 - CS :: The Database Environment

CSE :: Database System 2 - CS

Database System 2 - CS - Advanced SQL
Database System 2 - CS - SQL Server 2000
Database System 2 - CS - Data Warehousing
Database System 2 - CS - XML and ADO.NET
Database System 2 - CS - Database Redesign
Database System 2 - CS - Introduction to SQL
Database System 2 - CS - Distributed Databases
Database System 2 - CS - Client Server Database
Database System 2 - CS - Data Modeling with ER
Database System 2 - CS - Logical Database Design
Database System 2 - CS - Introduction to Database
Database System 2 - CS - Object Oriented Database
Database System 2 - CS - Physical Database Design
Database System 2 - CS - The Database Environment
Database System 2 - CS - ODBC, OLE DB, ADO, and ASP
Database System 2 - CS - ER Model and Business Rules
Database System 2 - CS - Database Processing for BIS
Database System 2 - CS - Managing Multiuser Databases
Database System 2 - CS - Object Oriented Data Modeling
Database System 2 - CS - Managing Databases with Oracle
Database System 2 - CS - SQL for Database Construction
Database System 2 - CS - Data and Database Administration
Database System 2 - CS - Data Models into Database Designs
Database System 2 - CS - Modeling Data in the Organization
Database System 2 - CS - The Database Development Process
Database System 2 - CS - The Internet Database Environment
Database System 2 - CS - JDBC, Java Server Pages, and MySQL
Database System 2 - CS - Database Design Using Normalization
Database System 2 - CS - The Relational Model and Normalization
  1. A data warehouse uses:

    2. A.

     partial operational data.
    B.

     historical operational data.
    C.

     future operational data.
    D.

     health care data.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    3. A.

     sample data.
    B.

     understand what data exist.
    C.

     what the fine distinctions are between similar data items.
    D.

     what the data mean.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    4. A.

     the data formats may be inconsistent.
    B.

     data values may not agree.
    C.

     Both A & B.
    D.

     Neither A & B.

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Legacy data is which of the following?

    5. A.

     Data contained in a newly-installed system
    B.

     Data rejected during the installation of a new system
    C.

     Data contained in a file system
    D.

     Data contained by a system used prior to the installation of a new system

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    6. A.

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

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

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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    7. A.

     Add records
    B.

     Read records
    C.

     Update records
    D.

     All of the above.

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. An enterprise data model is:

    8. A.

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

     a graphical model that shows all entities for an organization.
    C.

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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. A shared database should:

    9. A.

     be accurate and available.
    B.

     provide for backup and recovery.
    C.

     be secure.
    D.

     All of the above.

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Data administrators are responsible for:

    10. A.

     physical database design.
    B.

     managing technical issues in the database environment.
    C.

     overall management of data resources in an organization.
    D.

     writing application programs.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    11. A.

     Personal
    B.

     Workgroup
    C.

     Department
    D.

     Enterprise

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers