Menu
Home / CSE / Database Systems :: Section 2

CSE :: Database Systems

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

  1. A _____ means that one record in a particular record type may be related to more than one record of another record type.

    2. A.
    One-to-one relationship
    B.
    One-to-many relationship
    C.
    Many-to-one relationship
    D.
    Many-to many relationship
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which command(s) is(are) used to redefine a column of the table in SQL ?

    3. A.
    ALTER TABLE
    B.
    DEFINE TABLE
    C.
    MODIFY TABLE
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

    4. A.
    DEFINE TABLE
    B.
    MODIFY TABLE
    C.
    ALTER TABLE
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. In SQL, the ALTER TABLESPACE command is used

    5. A.
    to add/rename data files
    B.
    to change storage characteristics
    C.
    to take a tablespace online/offline
    D.
    to begin/end a backup
    E.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. The language used in application programs to request data from the DBMS is referred to as the

    6. A.
    DML
    B.
    DDL
    C.
    query language
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. A database management system might consist of application programs and a software package called

    7. A.
    FORTRAN
    B.
    AUTOFLOW
    C.
    BPL
    D.
    TOTAL
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. An audit trail

    8. A.
    is used to make back-up copies
    B.
    is the recorded history of operations performed on a file
    C.
    can be used to restore lost information
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. A race condition occurs when

    9. A.
    Two concurrent activities interact to cause a processing error
    B.
    two users of the DBMS are interacting with different files at the same time
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. An indexing operation

    10. A.
    sorts a file using a single key
    B.
    sorts file using two keys
    C.
    establishes an index for a file
    D.
    both (b) and (c)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

    11. A.
    forecasting report
    B.
    exception report
    C.
    regularly scheduled report
    D.
    on demand report
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers