Online Access Free 000-612 Practice Test

What two parameters allow DB2to keep a copy of a dynamically prepared statement in the cache?

• A.KEEPDYNAMIC(YES) and CACHEDYN=YES
• B.KEEPDYNAMIC(NO) and CACHEDYN=NO
• C.KEEPDYNAMIC(NO) and REOPT(ALWAYS)
• D.KEEPDYNAMIC(YES) and REOPT(ALWAYS)

In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)

• A.Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
• B.Column LEAFDIST in SYSIBM.SYSINDEXPART
• C.Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
• D.Column CLUSTERING in SYSIBM.SYSINDEXES
• E.Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

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

• A.Storage requirements for EDMDBDC will decrease.
• B.Storage requirements for some applications will increase.
• C.The dynamic statement cache should be increased to handle the additional SQL statements.
• D.DSMAX may have to be increased.

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

• A.Always have a performance trace running.
• B.Perform a DISPLAY DATABASE (LOCKS ) command often.
• C.Turn on a monitortrace.
• D.Always have statistics classes 1,3, and 4 and accounting classes 1 and 3 running.

If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

• A.One sort in the plan step will accomplish twotasks.
• B.There are multiple sorts in the plan step.
• C.Two sorts are performed on the new table of a star join.
• D.The next sort step will perform two sorts.