What Do You Know About IBM Db2? Trivia Quiz!

8 Questions | Total Attempts: 592

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Related Topics
Questions and Answers
  • 1. 
    The concept of cursor in DB2 is similar to?
    • A. 

      Pointer

    • B. 

      Table

    • C. 

      View

    • D. 

      Data

  • 2. 
    What is primary and foreign key?
    • A. 

      Primary is unique and foreign key should be a primary key of other

    • B. 

      Both functions are same

    • C. 

      Foreign key is used to relate two tables

  • 3. 
    DB2 ultimately saves all the data in which format of file?
    • A. 

      VSAM LDS

    • B. 

      VSAM KSDS

    • C. 

      VSAM RRDS

    • D. 

      VSAM ESDS

  • 4. 
    Which is the function used to retrieve all the rows without eliminating duplicate values?
    • A. 

      JOIN

    • B. 

      UNION

    • C. 

      UNION ALL

    • D. 

      DISTINCT

  • 5. 
    Which one is not a DB2 Object?
    • A. 

      TABLE

    • B. 

      DATABASE

    • C. 

      INDEX

    • D. 

      TABLESPACE

    • E. 

      INDEXSPACE

    • F. 

      STORAGE GROUP

  • 6. 
    How many Isolation levels are available?
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      5

  • 7. 
    Alias is a global object and can be accessed by all?
    • A. 

      True

    • B. 

      False

  • 8. 
    What is the PIC clause for SQLCODE?
    • A. 

      +9(3)

    • B. 

      S9(9) COMP

    • C. 

      S9(4) COMP-3

    • D. 

      S9(9) COMP-3