Db2 Sc Training 2013 - Day 2

42 Questions | Total Attempts: 32

SettingsSettingsSettings
Please wait...
Training Quizzes & Trivia

Questions and Answers
  • 1. 
    1. BMCSTATS can help a customer find potential LOB column candidates for "Inlining"
    • A. 

      True

    • B. 

      False

  • 2. 
    BMCSTATS ATBWORKAREA (Above the Bar workarea) is good if you are encountering:
    • A. 

      Performance problems during your Stats Run

    • B. 

      Memory problems during your Stats Run

    • C. 

      Both a and b

    • D. 

      None of the Above

  • 3. 
    “QUIESCINTERVAL” was put into place to address BMCSTATS runs that pull in the world.
    • A. 

      True

    • B. 

      False

  • 4. 
    BMCTRIG can run against the following threshold items without requiring BMCSTATS.
    • A. 

      DB2 RTS based evaluations

    • B. 

      DB2 Object Status evaluations

    • C. 

      Physical dataset evaluations

    • D. 

      All of the Above

  • 5. 
    Customers will have the ability to request System Triggers not apply to Copy Exceptions.
    • A. 

      True

    • B. 

      False

  • 6. 
    Common Object Sets can be used by the following products (Select all that Apply)                
    • A. 

      Copy Plus

    • B. 

      DASD Manager

    • C. 

      Recovery Manager

    • D. 

      Recover Plus

  • 7. 
    DASD Manager will allow you to Preview which of the products artifacts (Select all that Apply)
    • A. 

      Services

    • B. 

      Actions

    • C. 

      Syntax

    • D. 

      Triggers

  • 8. 
    Customers must be careful when they are reviewing a Syntax definition, since there is no way for them to look at the definition without risking modifying the definition.
    • A. 

      True

    • B. 

      False

  • 9. 
    Which of the following statements describe DASD Manager’s new scrollable syntax options dialogs:  (Select all that Apply)    
    • A. 

      Navigation to secondary dialogs is mineralized

    • B. 

      Options are organized by category

    • C. 

      They are left right scrollable as well as up and down

    • D. 

      Uses syntax keywords for prompts when possible

    • E. 

      Find capability to search text

  • 10. 
    The FIND command in the Syntax Options Dialogs will search the following areas:
    • A. 

      The option descriptions

    • B. 

      The option labels

    • C. 

      The user specified values

  • 11. 
    Where would I go to find trip reports from IDUG?
    • A. 

      The DB2 for z/OS Sharepoint site, under “V10 Documents”.

    • B. 

      The public library.

    • C. 

      The Trip Report Chatter group.

    • D. 

      The DB2 for z/OS Sharepoint site, under “Conference Proceedings, Trip Reports, Etc.”

  • 12. 
     Where would I go to find details of what’s planned for V11.1 of Reorg Plus?
    • A. 

      I’d ask Randy Bright.

    • B. 

      PMO R&D Sharepoint site, DFD – Database Performance for DB2, DFD.11.1.00 (not there yet)

    • C. 

      PMO R&D Sharepoint site, Reorg Plus, V11.1.00

    • D. 

      The Reorg Plus V11.1 Chatter group.

  • 13. 
    Where would I go to find the support team for System Performance for DB2?
    • A. 

      The DB2 Support Sharepoint site, under “DB2 SYS PERF US SUPPORT”

    • B. 

      The DB2 Support Sharepoint site, under “SC Assignments”

    • C. 

      I’d ask Lee Wetmore.

    • D. 

      The System Performance Chatter group.

  • 14. 
    Where would I find a list of DB2 11 ESP customers and their current status?
    • A. 

      It doesn't exist

    • B. 

      The DB2 for z/OS Sharepoint site, under “Conference Proceedings, Trip Reports, Etc.”

    • C. 

      SFDC

    • D. 

      The DB2 for z/OS Sharepoint site, under “DB2 11 Documents”, file “Sequoia Customers”

  • 15. 
    In BMC Workbench for DB2, the default plan table owner for dynamic explain is BMC.
    • A. 

      True

    • B. 

      False

  • 16. 
    In BMC Workbench for DB2, user will be able to compare access paths generated for a statement on two different subsystems.
    • A. 

      True

    • B. 

      False

  • 17. 
    Which of the following statements are true for BMC Workbench for DB2:
    • A. 

      By default, the user will not be able to generate explain plans if the user does not have the appropriate DB2 privileges.

    • B. 

      Setting the “Run Authorized” configuration option to “YES” allows the product to acquire SYSADM authority for processing explain request.

    • C. 

      All of the above

  • 18. 
    In Workspace Manager you can share your work with others by creating a template. 
    • A. 

      True

    • B. 

      False

  • 19. 
    A site must have a Catalog Manager or DAD license in order to use the Workbench.
    • A. 

      True

    • B. 

      False

  • 20. 
    The TN list shows a list of:
    • A. 

      Synonyms

    • B. 

      Packages

    • C. 

      Foreign keys

    • D. 

      All of the Above

    • E. 

      None of the Above

  • 21. 
    Cascade Batch report deals with the effects of a revoke.
    • A. 

      True

    • B. 

      False

  • 22. 
    Catalog Manager  11.1 is tolerant of DB2V11 and supports the following new lists:
    • A. 

      VAR and IXC

    • B. 

      VIX and ICC

    • C. 

      DOG and CAT

    • D. 

      IRA and SEP

  • 23. 
    “DIS ?”  displays a template to create a DB2 display command
    • A. 

      True

    • B. 

      False

  • 24. 
    Catalog Manager for DB2 is one of industry leading database administration products.
    • A. 

      True

    • B. 

      False

  • 25. 
     In Change Manager what are valid use cases for the Stop List for Analysis?
    • A. 

      Tables with Data Capture turned on

    • B. 

      Tables registered in an IDAA device

    • C. 

      Critical Application Tables

Back to Top Back to top