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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • What will occur when a database administrator adds a new automatic storage path to...

  • Which monitoring tool can be used to obtain stripe set information for database ma...

  • Which statement about value compression is correct?

  • What advantage do block-based buffer pools offer compared to regular buffer pools?

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

  • Which monitoring tool can be used to find out how many data pages have been read f...

  • What is the FAILARCHPATH database configuration parameter used for?

  • An auxiliary HADR standby database must use which HADR sync mode?

  • What is the recommended method for removing old backup images and log files for a ...

  • Which diagnostic tool can be used to collect metrics on individual SQL statement e...

  • What two types of information can be obtained with the MON_GET_TABLESPACE monitor ...

  • Where is the HADR_TARGET_LIST configuration parameter set?

  • Which statement about dropped table recovery is correct?

  • A table space creation operation was unsuccessful because DB2 failed to allocate a...

  • What must you do before an online table space backup operation can be performed?

  • Which category must be enabled before db2audit will record the creation of new buf...

  • What event category is used with the db2audit command to capture SQL data, such as...

  • A database administrator created all of the necessary federated objects for an SQL...

  • What are two supported methods for providing a low latency, high speed interconnec...

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

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings