Db2 Mock Test Quiz

10 Questions

Settings
Mock Test Quizzes & Trivia

.


Questions and Answers
  • 1. 
    ENTITY INTEGRITY is a state where column that is part of a primary key can have null values.                 
    • A. 

      True

    • B. 

      False

  • 2. 
    . SQLCODE -922 is for authorization failure
    • A. 

      True

    • B. 

      False

  • 3. 
    We Can use MAX on a CHAR column
    • A. 

      True

    • B. 

      False

  • 4. 
    Every SQL statement is executable.
    • A. 

      True

    • B. 

      False

  • 5. 
    SUBSTR(CUSTNAME,1,3) will extract 1st 3 character from CUSTNAME string
    • A. 

      True

    • B. 

      False

  • 6. 
    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?
    • A. 

      Views

    • B. 

      Aliases

    • C. 

      Indexes

  • 7. 
    Which one of the following is NOT a DB2 object?
    • A. 

      Synonym

    • B. 

      Table

    • C. 

      Column

  • 8. 
    What does a positive value of SQL code mean?
    • A. 

      Error

    • B. 

      Successful execution

    • C. 

      No rows found

  • 9. 
    AUTOMATIC RECOMPILATION occurs when
    • A. 

      A existing index is dropped.

    • B. 

      A new index is created.

    • C. 

      Both (A) and (B).

  • 10. 
    The final result of a DB2 BIND is
    • A. 

      Data Base Request Module

    • B. 

      DB2 (application) Plan

    • C. 

      DB2 catalog