최신 IBM Certified Database Administrator 000-611 무료샘플문제:

1. What authority is required to create, alter and drop workload management objects?

A) ACCESSCTRL
B) SYSADM
C) WLMADM
D) SECADM

2. A partitioned table named SALES was created as follows:

Which statement about the PARTS_IDX index is true?

A) The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.
B) The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
C) The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
D) The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space
TBSP3.

3. Which statement about BEFORE triggers is FALSE?

A) A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.
B) A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.
C) A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.
D) A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

4. Which tool should be used to collect data during a potential hang without stopping the database manager?

A) db2fodc
B) db2cklog
C) db2dart
D) db2ls

5. How is the time that an agent waits for log records to be flushed to disk calculated?

A) LOG_FLUSH_TIME divided by TOTAL_COMMITS
B) LOG_WRITE_TIME divided by TOTAL_COMMITS
C) LOG_WAIT_TIME divided by TOTAL_COMMITS
D) LOG_END_TIME divided by TOTAL_COMMITS

질문과 대답: