Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

  1. In SQL, which command is used to select data in rows and column from one or more tables?

  2. A.
    CHOOSE
    B.
    SELECT
    C.
    LIST
    D.
    BROWSE
    E.
    None of the above

  3. A scheme describes

  4. A.
    data elements
    B.
    records and files
    C.
    record relationships
    D.
    All of the above
    E.
    None of the above

  5. A report form

  6. A.
    appears on the computer monitor during data entry
    B.
    is used during report generation to format data
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above

  7. A computer file can be best described as

  8. A.
    a single data item
    B.
    a general collection of data items
    C.
    an orderly collection of data items
    D.
    a random collection of data items
    E.
    None of the above

  9. A good query system

  10. A.
    can accept English language commands
    B.
    allows non-programmers to access information stored in a database
    C.
    can be accessed only by data processing professionals
    D.
    both (a) and (b)
    E.
    None of the above

  11. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

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

  13. The modify operation is likely to be done after

  14. A.
    Delete
    B.
    Look-up
    C.
    Insert
    D.
    All of the above
    E.
    None of the above

  15. One data dictionary software package is called

  16. A.
    DB/DC dictionary
    B.
    TOTAL
    C.
    ACCESS
    D.
    any of the above
    E.
    None of the above

  17. One approach to standardizing storing of data

  18. A.
    MIS
    B.
    structured programming
    C.
    CODASYL specifications
    D.
    All of the above
    E.
    None of the above

  19. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

  20. A.
    Special purpose packages
    B.
    Custom made programs
    C.
    Single function application packages
    D.
    Data management packages
    E.
    None of the above