Dovetail Phase 2 (All Topics)

221 Questions | Total Attempts: 1145

SettingsSettingsSettings
Please wait...
Computer Software Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Block indexes for multiple columns produces
    • A. 

      Blocks

    • B. 

      Clusters

    • C. 

      Multidimensional Clusters

    • D. 

      None

  • 2. 
    Database partition is known as
    • A. 

      Leaf

    • B. 

      Node

    • C. 

      Root

  • 3. 
    Block indexes are preferable for high cardinality columns.
    • A. 

      True

    • B. 

      False

  • 4. 
    What does page cleaner do?
    • A. 

      Data from the buffer pool is written to the disk

    • B. 

      No Buffer

    • C. 

      Data from the buffer pool is written to the page

  • 5. 
    What is meant by pre-fetching?           
    • A. 

      Fetching data from hard disk to buffer pool

    • B. 

      Fetching data from page to buffer pool

    • C. 

      None

  • 6. 
    Statistics update is done 
    • A. 

      Once a week

    • B. 

      Depending on frequency of table updates.

    • C. 

      Once a Month

  • 7. 
    A database partition is not given complete control of Hardware resource  
    • A. 

      In Logical Partition

    • B. 

      In Primary Partition

    • C. 

      In Secondary Partition

  • 8. 
    Which is true?
    • A. 

      Database partition consists its own data, index, config files and transaction logs

    • B. 

      Database partition consists its own data, index, config files except transaction logs

    • C. 

      Database partition consists its own data, index and transaction logs except config files

  • 9. 
    MPP –
    • A. 

      Massively Parallel Processing

    • B. 

      Maximum Parallel Processing

    • C. 

      Minimum Parallel Processing

    • D. 

      Marginal Parallel Processing

  • 10. 
    Large updates and transactions are not suitable for
    • A. 

      Block index

    • B. 

      B+ tree index

    • C. 

      Clustered index

  • 11. 
    The No. of CPUs used in DB2 Enterprise edition
    • A. 

      2

    • B. 

      4

    • C. 

      No restriction

  • 12. 
    Tablespace span across containers and tables can span across tablespaces
    • A. 

      True

    • B. 

      False

  • 13. 
    Different table spaces have different page sizes
    • A. 

      True

    • B. 

      False

  • 14. 
    If Num_oicleaners is 0,then _____ are started
    • A. 

      No page cleaners

    • B. 

      Page Cleaners

    • C. 

      None

  • 15. 
    Effects of locking –    
    • A. 

      Improves concurrency

    • B. 

      Degrades performance

    • C. 

      Degrades concurrency

    • D. 

      Improves performance

  • 16. 
    What is ASLheapsz?
    • A. 

      It is the Communication buffer between the local application and its associated Agent.

    • B. 

      Error Agent

    • C. 

      Local Error Handler

  • 17. 
    True for Chngpgs_thresh:
    • A. 

      For heavy update transactions, decrease this value below default.

    • B. 

      Percentage of changed pages in Buffer pool at which the asynchronous page cleaners will be started, if they are not currently active.

    • C. 

      For heavy update transactions, increase this value below default.

  • 18. 
    Multi Dimensional Clusters are  Beneficial For
    • A. 

      OLAP

    • B. 

      MOLAP

    • C. 

      ROLAP

    • D. 

      None

  • 19. 
    SMS-
    • A. 

      Allocates space on demand

    • B. 

      The File Manager of operating system allocates and manages space

    • C. 

      System Managed Space

  • 20. 
    A container is not a
    • A. 

      Raw device

    • B. 

      Directory

    • C. 

      File

    • D. 

      Memory

  • 21. 
    Locklist 
    • A. 

      Increase this value if there is a problem with lock escalation.

    • B. 

      Memory that holds information about locks held by all applications concurrently connected to the database

    • C. 

      Decrease this value if there is a problem with lock escalation.

  • 22. 
    Default page size in DB2?
    • A. 

      32 KB

    • B. 

      16 KB

    • C. 

      8 KB

    • D. 

      4 KB

  • 23. 
    Not a DB2 licence method
    • A. 

      CPU

    • B. 

      User

    • C. 

      Memory

  • 24. 
    If the user wants particular attribute to be displayed in the report o/p, include the attribute in
    • A. 

      None

    • B. 

      Browse form

    • C. 

      Report display form

    • D. 

      Report layout form

  • 25. 
    True about Drill across? 
    • A. 

      A hierarchy can be used as a drill path

    • B. 

      The destination is shown as part of the other.

    • C. 

      A hierarchy cannot be used as a drill path

    • D. 

      The Source is shown as part of the other.