IBM C2090-611 Certification Practice Questions & Answers

Question 6 of 118

Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

A.

db2set ALT_DIAGPATH=/db2data/db2dump2

B.

db2set SECONDARY_DIAGPATH=/db2data/db2dump2

C.

UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

D.

UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Question 7 of 118

What is the MAX_LOG database configuration parameter used for?

A.

To limit how many log files a single transaction can span.

B.

To limit the percentage of primary log space a running transaction can consume.

C.

To limit the total number of primary and secondary log files a database can consume.

D.

To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.

Question 8 of 118

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

A.

CPU cycles

B.

Elapsed time, in milliseconds

C.

Processing instructions performed

D.

Timerons

Question 9 of 118

In IBM Data Studio, where can you schedule script-based jobs?

A.

Job Console

B.

Job Manager

C.

Task Manager

D.

Utilities Console

Question 10 of 118

The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:

What commands must be run to enable real-time statistics collection on the SAMPLE database?

A.

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

B.

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

C.

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

D.

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;