Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

  1. A multiple-form file management system

  2. A.
    lets you define different forms for different operations
    B.
    lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
    C.
    both (a) and (b)
    D.
    allow you to entry data in all the forms
    E.
    None of the above

  3. The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.

  4. A.
    Database
    B.
    Table
    C.
    Flat file
    D.
    Data structure
    E.
    None of the above

  5. A _____ Contains fields of data about one entity.

  6. A.
    Record
    B.
    File
    C.
    Fields
    D.
    Document
    E.
    None of the above

  7. A condition that led to the development of databases was

  8. A.
    a demand for more data to support information needs
    B.
    an increase in the amount of data handled by organizations
    C.
    the proliferation of data files
    D.
    All of the above
    E.
    None of the above.

  9. The _____ command is used to allocates an extent for the table in SQL

  10. A.
    MODIFY ALLOCATES
    B.
    MODIFY TABLE
    C.
    ALTER TABLE
    D.
    REDEFINE TABLE
    E.
    None of the above

  11. Embedded pointer provide

  12. A.
    a secondary access path
    B.
    a physical record key
    C.
    an inverted index
    D.
    All of the above
    E.
    None of the above

  13. Which of the following is a type of DBMS software?

  14. A.
    database manipulation language
    B.
    query language
    C.
    utilities
    D.
    report writer
    E.
    All of the above

  15. Data items grouped together for storage purposes are called a

  16. A.
    record
    B.
    title
    C.
    list
    D.
    string
    E.
    None of the above

  17. The activity of a file

  18. A.
    is a low percentages of number of records added or deleted from a file
    B.
    if high, reduces processing efficiency for sequential and nonsequential files
    C.
    is a measure of the percentage of existing records updated during a run
    D.
    refers to how closely the files fits into the allocated
    E.
    None of the above.

  19. Versatile report generators can provide

  20. A.
    Columnar totals
    B.
    Subtotals
    C.
    Calculations
    D.
    All of the above
    E.
    None of the above