Menu
Home / CSE MCQs / DB2 MCQs ::

CSE MCQs :: DB2 MCQs

DB2 MCQs -
  1. How many clustering index we can have for a single table?
    2. A.
    15
    B.
    10
    C.
    1
    D.
    No Limit

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following allow you to perform administrative tasks against database objects?
    3. A.
    Control Center
    B.
    Journal
    C.
    Task Center
    D.
    Health Center

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. AUTOMATIC RECOMPILATION occurs when
    4. A.
    A existing index is dropped
    B.
    A new index is created
    C.
    Both A and B
    D.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. The final result of a DB2 BIND is
    5. A.
    Load module
    B.
    DB2 catalog
    C.
    Data base request module
    D.
    DB2 (application) Plan

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. An INSERT statement:
    6. A.
    May contain a subquery
    B.
    Must contain a VALUES list
    C.
    Must contain a column list
    D.
    May create multiple table rows

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. How can the locks be classified?
    7. A.
    Size
    B.
    Duration
    C.
    Mode
    D.
    All of these

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?
    8. A.
    Views
    B.
    Aliases
    C.
    Indexes
    D.
    Mirrored tables

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following DB2 tools allows a user to set DB2 registry parameters?
    9. A.
    Task Center
    B.
    Visual Explain
    C.
    Configuration Assistant
    D.
    Satellite Administration Center

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. In DB2, DATA is physically stored in
    10. A.
    VSAM ESDS
    B.
    VSAM KSDS
    C.
    VSAM LDS
    D.
    TABLES

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. SQL was first developed:
    11. A.
    In the 1970s
    B.
    In 1982
    C.
    By IBM
    D.
    By ANSI

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers