Home / CSE / Database System 2 - CS :: Introduction to Database

CSE :: Database System 2 - CS

  1. The DBMS acts as an interface between what two components of an enterprise-class database system?

  2. A.

     Database application and the database

    B.

     Data and the database

    C.

     The user and the database application

    D.

     Database application and SQL


  3. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

  4. A.

     IDMS

    B.

     DB2

    C.

     dBase-II

    D.

     R:base


  5. The following are components of a database except ________ .

  6. A.

     user data

    B.

     metadata

    C.

     reports

    D.

     indexes


  7. An application where only one user accesses the database at a given time is an example of a(n) ________ .

  8. A.

     single-user database application

    B.

     multiuser database application

    C.

     e-commerce database application

    D.

     data mining database application


  9. An on-line commercial site such as Amazon.com is an example of a(n) ________ .

  10. A.

     single-user database application

    B.

     multiuser database application

    C.

     e-commerce database application

    D.

     data mining database application


  11. Which of the following products was the first to implement true relational algebra in a PC DBMS?

  12. A.

     IDMS

    B.

     Oracle

    C.

     dBase-II

    D.

     R:base


  13. SQL stands for ________ .

  14. A.

     Structured Query Language

    B.

     Sequential Query Language

    C.

     Structured Question Language

    D.

     Sequential Question Language


  15. Because it contains a description of its own structure, a database is considered to be ________ .

  16. A.

     described

    B.

     metadata compatible

    C.

     self-describing

    D.

     an application program


  17. The following are functions of a DBMS except ________ .

  18. A.

     creating and processing forms

    B.

     creating databases

    C.

     processing data

    D.

     administrating databases


  19. Helping people keep track of things is the purpose of a(n) ________ .

  20. A.

     database

    B.

     table

    C.

     instance

    D.

     relationship