C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 3)

C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Given the following output:Which Explain procedure can be used to find the most ex...

  • A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUD...

  • A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ? d...

  • A query against the system catalog revealed that data for a table named SALES in a...

  • Which statement about compression dictionaries is FALSE?

  • Which would not significantly benefit from having the RUNSTATS command run on it?

  • Which tool provides the simplest method for monitoring buffer pool hit ratios?

  • Which is NOT a valid method for prefetching data?

  • The following query is executed frequently against the EMPLOYEE table: SELECT empi...

  • Which item is NOT eligible for adaptive compression?

  • Which statement about block indexes is correct?

  • The following query is executed frequently against the SALES table: SELECT sales_i...

  • A database named TEST and a storage group named SG_1 were created with these state...

  • When defining storage groups for multi-temperature data, storage paths are usually...

  • If the following commands complete successfully for a single partition database: C...

  • You recently added more storage to a table space and a rebalance operation was sta...

  • The following statement was used to create a table space named TBSP1 in a non-part...

  • Which operation can be performed by executing an ALTER STOGROUP statement?

  • Which statement about SMS table spaces is correct?

  • Which type of storage is utilized in the implementation of an effective and flexib...

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
    23 views
    people
    0 takers
    folder
    IBM

  • C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 3) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings