Home / CSE / Database Systems :: Section 2

CSE :: Database Systems

  1. A _____ means that one record in a particular record type is related to only one record of another record type.

  2. A.
    One-to-one relationship
    B.
    One-to-many relationship
    C.
    Many-to-one relationship
    D.
    Many-to-many relationship
    E.
    None of the above

  3. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

  4. A.
    Network
    B.
    Hierarchical
    C.
    Relational
    D.
    Object-Oriented
    E.
    None of the above

  5. In SQL, which command(s) is(are) used to redefine an index's future storage allocation

  6. A.
    ALTER INDEX
    B.
    REDEFINE INDEX
    C.
    MODIFY INDEX
    D.
    DO INDEX
    E.
    None of the above

  7. Which of the following is a serious problem of file management systems?

  8. A.
    difficult to update
    B.
    lack of data independence
    C.
    data redundancy
    D.
    program dependence
    E.
    All of the above

  9. With respect to data input, the most accurate description of batch control is

  10. A.
    dividing documents to be entered into batches
    B.
    controlling the input of each input clerk
    C.
    comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
    D.
    All of the above
    E.
    None of the above

  11. The model for a _____ resembles the hierarchical model in many respects.

  12. A.
    Network database
    B.
    Relational database
    C.
    Distributed database
    D.
    Hierarchical database
    E.
    None of the above

  13. A set of programs that handle a firm's data base responsibilities is called a

  14. A.
    Data Base Management System (DBMS)
    B.
    Data Base Processing System (DBPS)
    C.
    Data Management System (DMS)
    D.
    All of the above
    E.
    None of the above

  15. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called

  16. A.
    data field
    B.
    data record
    C.
    data file
    D.
    database
    E.
    None of the above

  17. Long-range planning report produced in an MIS are primarily designed for

  18. A.
    top management
    B.
    middle management
    C.
    lower management
    D.
    All of the above
    E.
    None of the above

  19. The model for a record management system might be

  20. A.
    handwritten list
    B.
    a Rolodex card file
    C.
    a business form
    D.
    All of the above
    E.
    None of the above