Db2 Sc Training 2013 - Day 1

20 Questions | Total Attempts: 33

SettingsSettingsSettings
Please wait...
Training Quizzes & Trivia

Questions and Answers
  • 1. 
    How many DBC Groups can be registered as the in one RTCS System Registry?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      As many as you want.

  • 2. 
    V2360 of the install allows you to:
    • A. 

      Reuse DBC and LGC

    • B. 

      Reuse NGL

    • C. 

      Reuse RTCS

    • D. 

      All of the Above

  • 3. 
    With V2360 of the install, the following products now require RTCS, DBC, and LGC: (Choose all that apply)
    • A. 

      GUD Workbench for DB2

    • B. 

      RMD/ARM Recovery Management/Recover Plus

    • C. 

      ACT CATALOG MANAGER for DB2

    • D. 

      PSS SQL Explorer for DB2

    • E. 

      ALM PACLOG for DB2

  • 4. 
    With V2360 of the install, the order in which you should run the jobs is:
    • A. 

      $B, $R, $G, $C, $U

    • B. 

      $B, $R, $U, $G, $C

    • C. 

      $B, $R, $G, $U, $C

  • 5. 
    Extra credit: Supply a mnemonic that you can use to remember the order in which the jobs should be run!
  • 6. 
    Roughly how many DB2 customers do we have today?
    • A. 

      550

    • B. 

      750

    • C. 

      950

    • D. 

      1050

  • 7. 
    What was the size of the Data Masking market in 2011?
    • A. 

      $100M

    • B. 

      $200M

    • C. 

      $50M

    • D. 

      $25M

  • 8. 
    What is the Recovery Healthcheck NOT designed to show?
    • A. 

      That BMC DB2 recovery tools are the best of breed

    • B. 

      That it is possible to recover lost DB2 data with only software

    • C. 

      Hardware strategies cannot help with major disasters

    • D. 

      It is possible to build a robust DB2 recovery strategy using only hardware technologies

  • 9. 
    What is the biggest fear executives have when moving SQL into production?
    • A. 

      It will return incorrect results

    • B. 

      It may adversely affect the performance of existing applications

    • C. 

      It will increase business to the extent that the company cannot cope

    • D. 

      It will bring down DB2

  • 10. 
    What is the major point of an IMS transparency solution?
    • A. 

      Data can be stored in DB2 whilst the application still issues IMS calls to access it

    • B. 

      People can retrain their IMS DBAs to work with something more useful, like DB2

    • C. 

      Only minor changes need to be made to existing IMS programs

    • D. 

      DB2 data can be moved to IMS and accessed using SQL

  • 11. 
    What is the number after “10”, according to IBM?
    • A. 

      XI

    • B. 

      Vnext

    • C. 

      11

    • D. 

      Sequoia

  • 12. 
    How can a customer move from DB2 9 NFM to DB2 11?
    • A. 

      Migrate directly to DB2 11 CM9.

    • B. 

      Migrate to DB2 10 CM9, then to NFM, then to DB2 11 CM.

    • C. 

      You’re screwed. Move to Oracle.

    • D. 

      Unload all data, install a new DB 11 subsystem, and load the data there.

  • 13. 
    What problem is driving customers to a 10 byte RBA/LRSN?
    • A. 

      They can convert a high RBA system to data sharing, but if the Delta is high enough, they will run out of LRSN.

    • B. 

      Log files are getting really, really big.

    • C. 

      Reordered Row Format didn’t put BMC out of business, so IBM came up with this.

    • D. 

      Some customers write more than 256 TB of log every couple of years

  • 14. 
    When can customers allow RBA’s or LRSN’s with values greater than 2 ** 48?
    • A. 

      As soon as they migrate to DB2 11.

    • B. 

      After migration to NFM.

    • C. 

      After migration to NFM, completion of DSNJCNVT utility, and reorg/rebuild of all spaces.

    • D. 

      After running a reorg

  • 15. 
    I could alter limit keys in DB2 10.  What’s the big deal in DB2 11?
    • A. 

      The space is not put in REORP in DB2 11, but in AREOR, so applications can continue to access the table.

    • B. 

      You can now alter 255 byte limit keys, instead of being limited to 40 bytes.

    • C. 

      Altering limit keys doesn’t bring down DB2 any more.

    • D. 

      You only have to reorg the partitions you altered now, instead of the whole tablespace.

  • 16. 
    When is IBM planning to GA DB2 11?
    • A. 

      September, 2013

    • B. 

      October, 2013

    • C. 

      January, 1900

    • D. 

      December, 2013

  • 17. 
    V10.2 of the BMC Utilities (Load, Unload, Reorg, and Check) will support DB2 11.
    • A. 

      True

    • B. 

      False

  • 18. 
    When will BMC provide support for Extended RBA?
    • A. 

      April, 2013

    • B. 

      December, 2014

    • C. 

      December, 2013

    • D. 

      October, 2013

  • 19. 
    ESP customers will have to reinstall SQL Performance after DB2 11 GA’s.
    • A. 

      True

    • B. 

      False

  • 20. 
    Why did BMC take so long to support LOB’s in the Utilities?
    • A. 

      We think LOB’s are a flash in the pan.

    • B. 

      We were busy doing XML support for State Farm.

    • C. 

      We have supported LOB’s for several releases. We deferred specific DB2 10 support to improve the quality of our releases.

    • D. 

      We had higher priorities, like Binary XML and Online Schema Change.

Back to Top Back to top