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

CSE :: Database System 2 - CS

  1. Which of the following is true for a relational database?

  2. A.

     Data is represented by tables.

    B.

     It is difficult to access data.

    C.

     Complex programs have to be written for simple queries.

    D.

     All of the above.


  3. Some advantages of the database approach include all, but:

  4. A.

     minimal data redundancy.

    B.

     improved data consistency.

    C.

     improved data sharing.

    D.

     program-data dependency.


  5. An enterprise database is which of the following?

  6. A.

     A database designed to support only users external to an organization

    B.

     A database designed to support an entire organization

    C.

     A database designed to support a relatively small group

    D.

     A database designed to support a single PC


  7. Structured data may include which of the following?

  8. A.

     Photo image

    B.

     Video clip

    C.

     Dates

    D.

     None of the above


  9. An extranet is which of the following?

  10. A.

     The use of Internet protocols with limited access to company data by the company's customers and suppliers.

    B.

     The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.

    C.

     The use of Internet protocols with limited access to company data by people within an organization.

    D.

     The use of Internet protocols with unlimited access to company data by people within an organization.


  11. All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

  12. A.

     True

    B.

     False


  13. Database management systems were first introduced in the 1950s.

  14. A.

     True

    B.

     False


  15. Databases that contain historical and summarized information are usually called data warehouses.

  16. A.

     True

    B.

     False


  17. An advantage of the database approach is the creation of maximum data redundancy.

  18. A.

     True

    B.

     False


  19. An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.

  20. A.

     True

    B.

     False