Free IBM C2090-312 Exam Dumps Questions & Answers

You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?

• A.  MAXKEEPD
• B.  MAXRBLK
• C.  CONTSTOR
• D.  MAXTEMPS

When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance?

• A.  CACHE
• B.  INCREMENT
• C.  MAXVALUE
• D.  RESET

What catalog table provides the information about missing or conflicting catalog statistics for SQL statements?

• A.  SYSIBM.SYSGUERYSEL
• B.  SYSIBM.SYSTATFEEDBACK
• C.  SYSIBM.SYSVARIABLES_TEXT
• D.  SYSIBM.SYSOUERYPREDICATE

A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?

• A.  A range-based temporal table
• B.  A rate-period temporal table
• C.  An application-period temporal table
• D.  A system-period temporal table

Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?

• A.  CLASS(1, 2,3,7,8)
• B.  CLASS(2,7,8)
• C.  CLASS(1,2,3)
• D.  CLASS(1,5,10)