IBM C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam
Page: 3 / 22
Total 108 questions
Question #11 (Topic: Topic 1)
Which Range-Clustered Tables (RCT) statement is correct?
A. Reverse scans on RCTs are not supported.
B. Clustering indexes are compatible with RCTs.
C. The Design Advisor can recommend the use of RCTs.
D. The IMPORT utility can be used with the REPLACE option to populate RCTs.
Answer: A
Question #12 (Topic: Topic 1)
Which monitoring tool can be used to find out how many data pages have been read from
the table space containers for regular, large, and temporary table spaces?
the table space containers for regular, large, and temporary table spaces?
A. The MON_DB_SUMMARY administrative view.
B. The MON_BP_UTILIZATION administrative view.
C. The MON_GET_ACTIVITY_DETAILS table function.
D. The MON_GET_EXTENT_MOVEMENT_STATUS table function.
Answer: B
Question #13 (Topic: Topic 1)
Which index(es) are created when a multidimensional clustering (MDC) table is defined
with only one dimension?
with only one dimension?
A. One composite block index and one unique index.
B. One composite clustering index and one dimension block index.
C. One index that serves as both the dimension block index and the composite block index.
D. One index that serves as both the dimension block index and the composite clustering index.
Answer: C
Question #14 (Topic: Topic 1)
A DBA wants to create a table named SALES that has the following characteristics:
? Data for the first half of the year will reside in table space TBSP1; the index for this
data will reside in table space TBSP21.
? Data for the second half of the year will reside in table space TBSP2; the index for
this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
? Data for the first half of the year will reside in table space TBSP1; the index for this
data will reside in table space TBSP21.
? Data for the second half of the year will reside in table space TBSP2; the index for
this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
A. DISTRIBUTE BY HASH
B. PARTITION BY RANGE
C. ORGANIZE BY DIMENSIONS
D. ORGANIZE BY KEY SEQUENCE
Answer: B
Question #15 (Topic: Topic 1)
Which statement about partitioned indexes is FALSE?
A. Both system- and user-generated indexes can be partitioned.
B. Each index partition contains references only to data in its corresponding data partition.
C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition
D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.
Answer: D
