IBM C2090-611 - DB2 10.1 DBA for Linux, UNIX, and Windows Exam
Page: 3 / 24
Total 116 questions
Question #11 (Topic: Topic 1)
Which statement describes a way to minimize the impact of a RUNSTATS operation?
A. Reduce I/O by using a shadow table space for statistics collection.
B. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.
C. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.
D. Limit the number of pages and rows processed by using page-level or row-level table sampling.
Answer: D
Question #12 (Topic: Topic 1)
Which statements will enable automatic storage in storage group SG_HOT for a given
database managed table space MY_TS and remove all existing non-automatic storage
containers from the table space?
database managed table space MY_TS and remove all existing non-automatic storage
containers from the table space?
A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTERTABLESPACE my_ts REBALANCE;
B. ALTER TABLEPACE my_ts MANAGED BY DATABASE; ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;
C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot; ALTER STOGROUPsg_hot DROP '/db2/filesystem1', '/db2/filesystem2'; ALTER TABLESPACE my_ts REBALANCE;
D. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot; ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2'; ALTER TABLESPACE my_ts REBALANCE;
Answer: A
Question #13 (Topic: Topic 1)
In IBMData Studio, where can you schedule script-based jobs?
A. Job Console
B. Job Manager
C. Task Manager
D. Utilities Console
Answer: B
Question #14 (Topic: Topic 1)
What are two purposes of the SET INTEGRITY statement? (Choose two.)
A. To bring a table out of "SetIntegrity Pending" state by performing the required integrity processing on the table.
B. To bring a table out of "Set Integrity Pending" state by performing only check constraint processing on the table.
C. To bring a table out of "Set Integrity Pending"state without performing the required integrity processing on the table.
D. To bring a table out of "Set Integrity Pending" state by performing only referential integrity constraint processing on the table.
E. To bring a table out of "Set Integrity Pending" state by performing only referential integrity and check constraint processing on the table.
Answer: A,C
Question #15 (Topic: Topic 1)
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM)
= ON (Inactive) Which statement is true?
= ON (Inactive) Which statement is true?
A. Self-tuning is occurring only on the instance memory area.
B. The memory tuner is actively tuning the memory on the system.
C. Self-tuning is not occurring because it is waiting for the database to be recycled.
D. Self-tuningis not occurring because there are less than two memory consumers enabled.
Answer: D
