Home / CSE / Database Systems :: Section 1

CSE :: Database Systems

  1. A database management system

  2. A.
    allows simultaneous access to multiple files
    B.
    can do more than a record management system
    C.
    is a collection of programs for managing data in a single file
    D.
    both (a) and (b)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the following hardware components is the most important to the operation of a database management system?

  4. A.
    high-resolution video display
    B.
    printer
    C.
    high speed, large-capacity disk
    D.
    plotter
    E.
    mouse

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. The PROJECT command will create new table that has

  6. A.
    more fields than the original table
    B.
    more rows than the original table
    C.
    both (a) and (b)
    D.
    all the fields of master table
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. To have a file hold a list, it is necessary to

  8. A.
    identify the records in the list
    B.
    identify the name, width and type of the fields of each record.
    C.
    decide which fields will be used as sort or index keys
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Sophisticated report generators can

  10. A.
    print row-oriented reports
    B.
    perform arithmetic operations
    C.
    selectively retrieve and print portions of a list
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

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

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which two files are used during operation of the DBMS?

  14. A.
    query language and utilities
    B.
    data manipulation language and query language
    C.
    data dictionary and transaction log
    D.
    data dictionary and query language
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. When using a database management system, the first thing that you must do is to

  16. A.
    create a database file
    B.
    activate file editor
    C.
    load the software into your micro¬computer
    D.
    keep a floppy disk in readiness
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. A network schema

  18. A.
    restricts the structure to a one-to-many relationship
    B.
    permits many-to-many relation¬ships
    C.
    stores data in tables
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Which of the following is not a relational database?

  20. A.
    dBASE IV
    B.
    4th Dimension
    C.
    FoxPro
    D.
    Reflex
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum