000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 2)

000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SS...

  • Which command will enable Oracle applications to work within a DB2 9.7 environment?

  • When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux...

  • Which statement describes the state of the DMS table space TBS_1 after the success...

  • After executing the following statement: ALTER TABLESPACE tbsp1 LOWER HIGH WATER M...

  • A database administrator wants to load XML data into the table DB2USER.T1 from the...

  • Which parameter can be used to compress XML data being LOADed into a table that re...

  • Which db2val option will create a log file?

  • A table named HR.PAYROLL resides in table space TS4 and has a page size of 4K. You...

  • You have created a table using the INLINE LENGTH option. Which function is used to...

  • How would you set the client information for a particular activity in a database u...

  • After using the lock event monitor to capture binary lock event data in an unforma...

  • Which of the following is NOT a valid workload name?

  • Which two registry variables that are normally used to delay or avoid acquiring lo...

  • Which two of the following can now be monitored with DB2 v9.7? (Choose two.)

  • If the statement concentrator is enabled and dynamic SQL is running, which stateme...

  • A database administrator wants to prune the Recovery History file for the SAMPLE d...

  • Which command will enable reads on an High Availability and Disaster Recovery (HAD...

  • The SAMPLE database is backed up and the recovery logs are included in the backup ...

  • Regardless of the value set for the mon_obj_metrics parameter, data is always coll...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    3 views
    people
    0 takers
    folder
    IBM

  • 000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 2) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings