Home / CSE / Database Systems :: Section 1

CSE :: Database Systems

  1. When you have finished entering information into a form

  2. A.
    the template is written to the data file
    B.
    the contents of the form are written to the data file
    C.
    the contents of the form can be printed
    D.
    All of the above
    E.
    None of the above

  3. The main idea behind computer files is that it is convenient to

  4. A.
    arrange them
    B.
    store information together
    C.
    create them
    D.
    access them
    E.
    None of the above

  5. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

  6. A.
    the pin code
    B.
    the last name
    C.
    a compound key consisting of the first name and the last name
    D.
    All of the above
    E.
    None of the above

  7. In SQL, which command is used to add new rows to a table?

  8. A.
    ALTER TABLE
    B.
    ADD ROW
    C.
    INSERT
    D.
    APPEND
    E.
    None of the above

  9. A number of related records that are treated as a unit is called

  10. A.
    file
    B.
    field
    C.
    data
    D.
    batch
    E.
    None of the above

  11. If you want to group the records in the abc database, you could use the Jobcode as the _____.

  12. A.
    Delete
    B.
    Update
    C.
    Sort Key
    D.
    Index
    E.
    None of the above

  13. The Management Information system (MIS) structure with one main computer system is called a

  14. A.
    hierarchical MIS structure
    B.
    distributed MIS structure
    C.
    centralized MIS structure
    D.
    decentralized MIS structure
    E.
    None of the above

  15. If a calculation is embedded in a form

  16. A.
    the result of the calculations are stored with the form
    B.
    the calculations are stored with the form
    C.
    the result of the calculations are printed in report
    D.
    All of the above
    E.
    None of the above