A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 2)

A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • What is a method for enabling non-buffered I/O at the table space level in a DB2 d...

  • A database and a table space were created using the following commands:Afterwards,...

  • What are the steps required to remove July 2005 data from a partitioned table and ...

  • The DBA needs to create a table with key columns YEARMONTH and YEAR. This table ne...

  • A DBA would like to examine repartitioning options for a partitioned database name...

  • How can a DBA validate that an existing backup was compressed?

  • If LOGSECOND=-1 then which of the following statements is true?

  • In order for HADR to start, which statement is true when setting the HADR_TIMEOUT ...

  • Which command CANNOT be used to create the compression dictionary for a table?

  • Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the sta...

  • Which command would be used to obtain the name of the first active log file for a ...

  • Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table ...

  • Which action(s) will cause a compression dictionary to be removed from a table?

  • Which statement is correct about statistical views?

  • Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry var...

  • Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do ...

  • Which database configuration parameters can be used to limit the amount of memory ...

  • Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an e...

  • What is the minimum authority required to execute the RUNSTATS command against a t...

  • What new security authorities have been introduced in DB2 V9.7?

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

  • A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 2) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings