Db2 Sc Training 2013 - Day 3

25 Questions | Total Attempts: 35

SettingsSettingsSettings
Please wait...
Training Quizzes & Trivia

Questions and Answers
  • 1. 
    Which System Performance products are supporting the DB2 11 ESP?
    • A. 

      Mainview for DB2

    • B. 

      Opertune

    • C. 

      Pool Advisor

    • D. 

      The System Performance Solution component

  • 2. 
    For the System Performance products supporting the DB2 11 ESP, which release will customers be required to run to participate in the ESP?
    • A. 

      10.1 with maintenance

    • B. 

      10.2with maintenance

    • C. 

      11.1 with maintenance

    • D. 

      11.2

  • 3. 
    Which versions of DB2 will be supported by the G/A 11.1 release of the System Performance products?
    • A. 

      8.1

    • B. 

      9.1

    • C. 

      10.1

    • D. 

      11.1

  • 4. 
    How will the LGC repository be managed in the 11.1 release?
    • A. 

      HFS Files

    • B. 

      RTCS private registry

    • C. 

      Either HFS files or RTCS registry

    • D. 

      RTCS registry or optional PARMLIB member containing optionset XML

  • 5. 
    Now that the new release of NGL supports compression, which of the following is the most important thing to consider when setting up Data Collector Output Groups for a site?
    • A. 

      How much less DASD the customer has available

    • B. 

      How many DB2s need to be monitored?

    • C. 

      How busy the DB2s are that must be monitored

    • D. 

      The volume of data to be collected and whether the data is generated from DB2 or from the Data Collector

  • 6. 
    Which of the following are part of our strategic direction but will not yet be implemented with the 11.1 G/A release?
    • A. 

      ZIIP engine exploitation

    • B. 

      Current DB2 and zOS release support

    • C. 

      End-to-end monitoring

    • D. 

      GUI/graphics exploitation

  • 7. 
    Which of the following DB2 ZPARMs affect the gathering of page set statistics?
    • A. 

      STATIME - Statistics Time Interval (Minutes)

    • B. 

      DSMAX - Maximum Data Sets Open at Once

    • C. 

      DSSTIME - Time between Reset of Data Set Stats

    • D. 

      None of the above

  • 8. 
    What controls whether or not MainView Infrastructure will use above the bar storage?
    • A. 

      REGION=0M

    • B. 

      MEMLIMIT=10G

    • C. 

      MEMLIMIT=100G

    • D. 

      None of the above

  • 9. 
    What information was added to the Application Workload Monitor views?
    • A. 

      Total CPU

    • B. 

      AVG CPU

    • C. 

      Objective Met

    • D. 

      None of the above

  • 10. 
    Does the new Utility Status view show BMC Utilities?
    • A. 

      Yes

    • B. 

      No

    • C. 

      Sometimes

    • D. 

      I Wish

  • 11. 
    Which of the following is true about APPTUNE in-DB2 collection cost?
    • A. 

      As of 10.1, much of it is offloaded to zIIP.

    • B. 

      It is always more than Detector's cost.

    • C. 

      It can be controlled by Efficiency filtering and Sampling with Extrapolation.

    • D. 

      It is always less than Query Monitor's cost.

  • 12. 
    What is the easiest way to remember the line command to edit section defaults in the APPTUNE filter?
    • A. 

      Call Dorothy.

    • B. 

      Put your cursor on the line and hit PF1.

    • C. 

      Put a ? on the line and look for "Edit the section defaults".

    • D. 

      Type HELP.

  • 13. 
    As of 11.1, you must stop and restart the DBC for DOMPLEX option changes to take effect.
    • A. 

      True

    • B. 

      False

  • 14. 
    Which of the following describes Package Explain?
    • A. 

      It tells what the access path would be if the statement were bound right now.

    • B. 

      You can specify priority delivery of the results.

    • C. 

      It is for dynamic statements residing in the cache.

    • D. 

      It tells the access path in effect for the static statement right now.

  • 15. 
    Which of the following is not an 11.1 feature providing faster report access?
    • A. 

      Server-side reduction

    • B. 

      Turbo filtering

    • C. 

      Reduction by program

    • D. 

      Workload focus

  • 16. 
    You must enable archiving in order to maintain a PADB.
    • A. 

      True

    • B. 

      False

  • 17. 
    Which of the following is not a table that is typically maintained by those who implement PADB?
    • A. 

      STMT_TEXT

    • B. 

      DAILY_STMT_SUMMARY

    • C. 

      WEEKLY_HOSTVAR_EXCEPTIONS

    • D. 

      DAILY_OBJ_STATISTICS

  • 18. 
    The general preference among implementors is for a centralized PADB.
    • A. 

      True

    • B. 

      False

  • 19. 
    Which of the following is true regarding the LOADIN file?
    • A. 

      It is used for event-based tables such as STMT_EXCEPTIONS.

    • B. 

      It is used strictly to append rows to a PADB table.

    • C. 

      It is a mechanism to avoid SQL manipulation of rows.

    • D. 

      It consists of LOAD utility control statements.

  • 20. 
    Managing PADB tables by partition eliminates the need for LOADIN files.
    • A. 

      True

    • B. 

      False

  • 21. 
    The new Copy Migration feature can be executed using which licenses?
    • A. 

      COPY PLUS

    • B. 

      RECOVER PLUS

    • C. 

      RECOVERY MANAGEMENT SOLUTION

    • D. 

      CHANGE MANAGER

    • E. 

      ADMINISRATION SOLUTION

  • 22. 
    Change Manager can generate EXPORT, IMPORT, and MIGRATE syntax.
    • A. 

      True

    • B. 

      False

  • 23. 
    Which of the following are provided by the V11.1 Recovery Progress Report feature?
    • A. 

      Catalog and Directory Support

    • B. 

      Objects Recovered in a Specified Timeframe

    • C. 

      Objects that have been changed in a Specified Timeframe

    • D. 

      Copy Time Estimates for a Specified Set of Objects

  • 24. 
    Log Master has considered BMCXCOPY analysis in DROP RECOVERY since version 9.1
    • A. 

      True

    • B. 

      False

  • 25. 
    Support for individual object recovery from a SYSTEM BACKUP is supported in V11.1
    • A. 

      Directly within Recover Plus

    • B. 

      COPY PLUS Copy Image Copy followed by DSNUTILB

    • C. 

      COPY PLUS Copy Image Copy followed by RECOVER PLUS

    • D. 

      It is not supported

Back to Top Back to top