Quiz: Database Mock Test

16 Questions | Total Attempts: 7223

SettingsSettingsSettings
Database Quizzes & Trivia

Here is a very interesting quiz which is a database mock test for you. We have prepared this quiz to test your knowledge of the database and how well you understand that. There are many questions on the topic in the quiz; you will need to answer as many correctly as you can. In the end, your score will be a reflection of your knowledge of the subject. Let's go for it. Best of luck to you!


Questions and Answers
  • 1. 
    ENTITY INTEGRITY is a state where a 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

    • D. 

      Mirrored tables

    • E. 

      table constraints

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

      Storage Group

    • B. 

      Table

    • C. 

      Synonym

    • D. 

      Column

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

      Warning

    • B. 

      Error

    • C. 

      Successful execution

    • D. 

      No rows found

  • 9. 
    AUTOMATIC RECOMPILATION occurs when
    • A. 

      An existing index is dropped.

    • B. 

      A new index is created.

    • C. 

      Both A and B

    • D. 

      None of the above

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

      Load-module

    • B. 

      DB2 catalog

    • C. 

      Database request module

    • D. 

      DB2 (application) Plan

  • 11. 
    In DB2, DATA is physically stored in
    • A. 

      VSAM ESDS.

    • B. 

      VSAM KSDS.

    • C. 

      VSAM LDS

    • D. 

      TABLES

  • 12. 
    DATABASE SERVICES doesn’t consist of  
    • A. 

      BIND

    • B. 

      RUNTIME SUPERVISOR

    • C. 

      PACKAGES.

    • D. 

      PRECOMPILER.

  • 13. 
    Count(*) will return -----------------if the target table is empty.
    • A. 

      0

    • B. 

      1

    • C. 

      2

    • D. 

      3

  • 14. 
    All PLANS are stored in ____DB2 directory[Blank][Blank]_____.
    • A. 

      SY.SYSPL

    • B. 

      SYPSL.SB

    • C. 

      SYSIBM.SYSPL

    • D. 

      None of these

  • 15. 
    An ______ is an ordered set of pointers to rows of a base table.
    • A. 

      Index

    • B. 

      Opened-file

    • C. 

      Auto-file

    • D. 

      None of these

  • 16. 
    .______ is a single bound DBRM with an optimized access path.
    • A. 

      Box

    • B. 

      Package

    • C. 

      File

    • D. 

      None of these

Related Topics
Back to Top Back to top