Home / CSE / Database Systems :: Section 2

CSE :: Database Systems

  1. The designer of a form includes

  2. A.
    filed designators
    B.
    prompts
    C.
    data
    D.
    both (a) and (b)
    E.
    None of the above

  3. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

  4. A.
    report writer
    B.
    query language
    C.
    data manipulation language
    D.
    transaction log
    E.
    None of the above

  5. Two files may be joined into a third file if

  6. A.
    they have a row in common
    B.
    they have a field in common
    C.
    they have no records with the same value in the common field
    D.
    both (b) and (c)
    E.
    None of the above

  7. Characteristic(s) of a distributed MIS structure is

  8. A.
    interactive sharing of the workload
    B.
    a multiprocessing environment
    C.
    computers supporting local DP operations
    D.
    All of the above
    E.
    None of the above

  9. The data-base environment has all of the following components except:

  10. A.
    users
    B.
    separate files
    C.
    data base
    D.
    data-base administrator
    E.
    None of the above

  11. The way a particular application views the data from the data base that the application uses is a :

  12. A.
    module
    B.
    relational model
    C.
    schema
    D.
    subschema
    E.
    None of the above

  13. A compound key

  14. A.
    is made up a several pieces of information
    B.
    uniquely identifies an item in a list
    C.
    both (a) and (b)
    D.
    is a combination of each unique key
    E.
    None of the above

  15. The distinguishable parts of a record are called

  16. A.
    files
    B.
    data
    C.
    fields
    D.
    database
    E.
    None of the above

  17. Large collections of files are called

  18. A.
    fields
    B.
    records
    C.
    databases
    D.
    file system
    E.
    None of the above

  19. The index consists of

  20. A.
    a list of keys
    B.
    pointers to the master list
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above