Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

  1. Which of the following is not true of the traditional approach to information processing?

  2. A.
    There is common sharing of data among the various applications
    B.
    It is file-oriented
    C.
    Programs are dependent on the files
    D.
    It is inflexible
    E.
    All of the above are true

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Batch processing is appropriate if

  4. A.
    a large computer system is available
    B.
    only a small computer system is available
    C.
    only a few transactions are involved
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

  6. A.
    DASD
    B.
    FMS
    C.
    EMMS
    D.
    DBMS
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Which of the following is not an advantage of the data-base approach?

  8. A.
    elimination of the data redundancy
    B.
    ability to associate related data
    C.
    increased security
    D.
    program/data independence
    E.
    All of the above are advantages

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. A data dictionary doesn't provide information about:

  10. A.
    where data is located
    B.
    the size of the disk storage device
    C.
    It allows a many-to-many relationship
    D.
    It is conceptually simple
    E.
    It will be the dominant data base of the future

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Data encryption techniques are particularly useful for

  12. A.
    reducing storage space requirements
    B.
    improving data integrity
    C.
    protecting data in data communication systems
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

  14. A.
    Database
    B.
    Table
    C.
    Record
    D.
    Flat File
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. A logical schema

  16. A.
    is the entire database
    B.
    is a standard way of organizing information into accessible parts
    C.
    describes how data is actually stored on disk
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Queries to a database

  18. A.
    are written in English
    B.
    can use aggregate functions like SUM and COUNT
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. In order to use a record management system

  20. A.
    You need to understand the low-level details of how information in stored
    B.
    You need to understand the model the record management system uses.
    C.
    Both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum