C2090-612

C2090-612 practice questions, page 4 of 6, with answer review and explanations.

Question 16

What START TRACE command provides detailed lock suspend and lock contention trace information?

  1. START TRACE(AUDIT)
  2. START TRACE(STATS) CLASS(1)
  3. START TRACE(PERFM) CLASS(30) IFCID(44,45)
  4. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)

Question 17

When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

  1. DSMAX may have to be increased.
  2. Storage requirements for EDMDBDC will decrease.
  3. Storage requirements for some applications will increase.
  4. The dynamic statement cache should be increased to handle the additional SQL statements.

Question 18

What would be a reason for altering the clustering index of a table?

  1. To increase free space.
  2. Because the clustering index has to match the primary index.
  3. To choose a clustering index to favor batch sequential processing.
  4. To choose a clustering index to promote sequential inserts at the end of the table space.

Question 19

What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?

  1. MAXRBLK
  2. MAXDBAT
  3. MAXKEEPD
  4. MAXTEMPS

Question 20

In the CFRM policy, what is the purpose of the PREFLIST?

  1. To identify the size of the structure.
  2. To identify all the DB2 members in the group.
  3. To identify the preferences for DB2 restart in the event of a disconnection.
  4. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.