Elevate - Db2 Spe2010 Quiz

14 Questions | Total Attempts: 53

SettingsSettingsSettings
Please wait...
Elevate - Db2 Spe2010 Quiz

.


Questions and Answers
  • 1. 
    Which of the following products are NOT changing names?
    • A. 

      R+/Change Accum

    • B. 

      High Speed Apply

    • C. 

      PACLOG

    • D. 

      All of the above

  • 2. 
    The new feature in BMC AMI Copy, ON ERROR INTEGRITY SKIP, will (select all that apply):
    • A. 

      Skip the corrupted space and continue to copy the other spaces

    • B. 

      Allow customer to find all of the damaged spaces in one job instead of one at a time when applications get errors

    • C. 

      Automatically calculate Chad Reiber's golf handicap

    • D. 

      All of the above

    • E. 

      None of the Above

  • 3. 
    Which of the following are newly documented Log Master limitations when processing CLONEs?
    • A. 

      Processing a clone that has been dropped and recreated -  not supported

    • B. 

      Processing of a base table that has been cloned, exchanged, clone dropped, clone recreated, then exchanged - not supported

    • C. 

      Processing cloned tables in OVERTIME mode - not supported

    • D. 

      All of the above

  • 4. 
    When present, the optional ARMHELP DD will contain information that describes the JCL and syntax requirements for the ARM program being executed. SPE2010 adds support for the ARMHELP DD to which of the following ARM programs?
    • A. 

      ARMBARC

    • B. 

      ARMBSRR

    • C. 

      ARMBGPS

    • D. 

      All of the above

  • 5. 
    1. With SPE2010, migration of Stats is now done under which authorization ID?
    • A. 

      Install SYSADM

    • B. 

      Submitting ID

    • C. 

      DBC STC Authorization ID

    • D. 

      Email address

  • 6. 
    1. With SPE2010, the EXECUTE SQL feature of the EXPLAIN interface can now limit maximum rows selected.  Maximum row limit is:
    • A. 

      999

    • B. 

      5000

    • C. 

      9999

    • D. 

      99999

  • 7. 
    1. SPE2010 now tracks Thread Cancel metrics.  These can be found in: (Select all that Apply)
    • A. 

      Apptune Reporting

    • B. 

      Apptune filters

    • C. 

      Apptune exception Reports

    • D. 

      None of the above

  • 8. 
    1. The new limit for overflow pointers in AMI Reorg for Db2 is
    • A. 

      Between 8 and 14 million pointers

    • B. 

      128 million pointers

    • C. 

      134 million per PBG part

    • D. 

      None of the above

  • 9. 
    1. What are some of the SMARTSWITCH restrictions for Unload Plus when using the Into Clause (select all that apply)
    • A. 

      Using the ROUND function

    • B. 

      Using the IF ERROR clause

    • C. 

      Using the DATE clause

    • D. 

      All of the Above

    • E. 

      None of the above

  • 10. 
    1. What new terminology is introduced with the October 2020 release (Select All that Apply)
    • A. 

      FIXCAT CATEGORY

    • B. 

      SPE2010

    • C. 

      BMC AMI

    • D. 

      None of the Above

  • 11. 
    1. What notable product is not being named AMI in the Admin portfolio?
    • A. 

      DASD Manager

    • B. 

      SQL Assurance

    • C. 

      Change Manager

    • D. 

      Catalog Manager

  • 12. 
    1. How will BMC AMI Change Manager and DASD Manager get ZPARM information going forward?
    • A. 

      Use the IBM supplied Stored Procedure

    • B. 

      From the DBD

    • C. 

      Directly from the Db2 Directory

    • D. 

      Thee products don't need the ZParm information

  • 13. 
    1. What was a new BMC AMI Catalog Manager list supported in the SPE2010?
    • A. 

      List of catalog table SYSPACKSTMT (PS)

    • B. 

      List of DBAs phone numbers (DA)

    • C. 

      List of BMC Catalog Manager developers (CM)

    • D. 

      List of PBR2 tables (T2)

  • 14. 
    1. True Teamwork was used to build BMC AMI SQL Assurance, how many teams were responsible for the COB product?
    • A. 

      4 – Catalog Manager, Command Center, SQL Explorer, and DevOps teams

    • B. 

      2 – DevOps and Catalog Manager Teams

    • C. 

      1 – SQL Performance Team

    • D. 

      1 Billion - Total number of Christmas lights Frank Rhodes and Jim Kurtz have

Back to Top Back to top