Menu
Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

Database Systems - Section 1
Database Systems - Section 2
Database Systems - Section 3
Database Systems - Section 4

  1. Which of the following is not true of the traditional approach to information processing?

    2. A.
    There is common sharing of data among the various applications
    B.
    It is file-oriented
    C.
    Programs are dependent on the files
    D.
    It is inflexible
    E.
    All of the above are true

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Batch processing is appropriate if

    3. A.
    a large computer system is available
    B.
    only a small computer system is available
    C.
    only a few transactions are involved
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

    4. A.
    DASD
    B.
    FMS
    C.
    EMMS
    D.
    DBMS
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which of the following is not an advantage of the data-base approach?

    5. A.
    elimination of the data redundancy
    B.
    ability to associate related data
    C.
    increased security
    D.
    program/data independence
    E.
    All of the above are advantages

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. A data dictionary doesn't provide information about:

    6. A.
    where data is located
    B.
    the size of the disk storage device
    C.
    It allows a many-to-many relationship
    D.
    It is conceptually simple
    E.
    It will be the dominant data base of the future

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Data encryption techniques are particularly useful for

    7. A.
    reducing storage space requirements
    B.
    improving data integrity
    C.
    protecting data in data communication systems
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

    8. A.
    Database
    B.
    Table
    C.
    Record
    D.
    Flat File
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. A logical schema

    9. A.
    is the entire database
    B.
    is a standard way of organizing information into accessible parts
    C.
    describes how data is actually stored on disk
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Queries to a database

    10. A.
    are written in English
    B.
    can use aggregate functions like SUM and COUNT
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. In order to use a record management system

    11. A.
    You need to understand the low-level details of how information in stored
    B.
    You need to understand the model the record management system uses.
    C.
    Both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers