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

CSE :: Database System 2 - CS

  1. Which of the following products implemented the CODASYL DBTG model?

  2. A.

     IDMS

    B.

     DB2

    C.

     dBase-II

    D.

     R:base


  3. An Enterprise Resource Planning application is an example of a(n) ________ .

  4. A.

     single-user database application

    B.

     multiuser database application

    C.

     e-commerce database application

    D.

     data mining database application


  5. A DBMS that combines a DBMS and an application generator is ________ .

  6. A.

     Microsoft's SQL Server

    B.

     Microsoft's Access

    C.

     IBM's DB2

    D.

     Oracle Corporation's Oracle


  7. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .

  8. A.

     user data

    B.

     metadata

    C.

     A report

    D.

     indexes


  9. Which of the following is not considered to be a basic element of an enterprise-class database system?

  10. A.

     Users

    B.

     Database applications

    C.

     DBMS

    D.

     COBOL programs


  11. The DBMS that is most difficult to use is ________ .

  12. A.

     Microsoft's SQL Server

    B.

     Microsoft's Access

    C.

     IBM's DB2

    D.

     Oracle Corporation's Oracle


  13. The DBMS that is most difficult to use is ________ .

  14. A.

     Microsoft's SQL Server

    B.

     Microsoft's Access

    C.

     IBM's DB2

    D.

     Oracle Corporation's Oracle


  15. The DBMS that is most difficult to use is ________ .

  16. A.

     Microsoft's SQL Server

    B.

     Microsoft's Access

    C.

     IBM's DB2

    D.

     Oracle Corporation's Oracle


  17. The DBMS that is most difficult to use is ________ .

  18. A.

     Microsoft's SQL Server

    B.

     Microsoft's Access

    C.

     IBM's DB2

    D.

     Oracle Corporation's Oracle


  19. The relational database model was created by E.F. Codd.

  20. A.

     True

    B.

     False