Db2 Mock Test Quiz

10 Questions | Total Attempts: 495
SettingsSettingsSettings
Please wait...
or Create Online Test
Mock Test Quizzes & Trivia

.

More Mock Test Quizzes
Kt And Ra Mock Question Kt And Ra Mock Question
Mock Test 1b Mock Test 1b
California Private Patrol Operator Ppo License Test California Private Patrol Operator Ppo License Test
Featured Quizzes
Can You Pass This Basic World History Quiz? Can You Pass This Basic World History Quiz?
Which Celebrity Do You Look Like Quiz? Which Celebrity Do You Look Like Quiz?
Quiz: The Best Pokemon Picker! Quiz: The Best Pokemon Picker!
Related Topics
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

Back to Top Back to top