IBM Db2 Database Quiz

10 Questions | Total Attempts: 137

SettingsSettingsSettings
Please wait...
IBM Db2 Database Quiz

IBM DB2 is a product that was developed by IBM. The most amazing part about this product is that it works on a relational model. Take this quiz, it's going to improve and ascertain your knowledge. Good Luck!


Related Topics
Questions and Answers
  • 1. 
    In which mode of Command Line Processor (CLP) must each command and SQL statements be prefixed by "db2"?
    • A. 

      Output mode

    • B. 

      Batch mode

    • C. 

      Command mode

    • D. 

      Interactive input mode

  • 2. 
    For DB2 Database Server, the default instance is:
    • A. 

      IBM2

    • B. 

      IBM1

    • C. 

      DB1

    • D. 

      DB2

  • 3. 
    Which of these expressions means no rows found?
    • A. 

      +101

    • B. 

      -101

    • C. 

      +100

    • D. 

      -100

  • 4. 
    The SQL return code "0" means:
    • A. 

      Successful execution

    • B. 

      Unsuccessful execution

    • C. 

      Error information

    • D. 

      Empty rows and columns

  • 5. 
    The following are constraints types except 
    • A. 

      NOT NULL

    • B. 

      Unique

    • C. 

      Conditional

    • D. 

      Information

  • 6. 
    A set of columns in a table which are required to match at least one primary key of a row in another table is
    • A. 

      Primary key

    • B. 

      Foreign key

    • C. 

      Unique

    • D. 

      Informational

  • 7. 
    The syntax for creating a sequence is
    • A. 

      Ibm sequence

    • B. 

      Db2 sequence

    • C. 

      Ibm create sequence

    • D. 

      Db2 create sequence

  • 8. 
    What is the physical storage length of DATE data type?
    • A. 

      20 bytes

    • B. 

      10 bytes

    • C. 

      4 bytes

    • D. 

      3 bytes

  • 9. 
    What does a positive SQL code indicates?
    • A. 

      Exception

    • B. 

      Failure

    • C. 

      Success

    • D. 

      None of the above

  • 10. 
    Which table space houses only one table?
    • A. 

      Partitioned Table space

    • B. 

      Segmented Table space

    • C. 

      Simple Table space

    • D. 

      All of the above