多项选择题

When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）

A.the query transaction rate
B.numeric data versus character data
C.extent size
D.the cardinality of the candidate columns
E.prefetch size

点击查看答案

上一题目录下一题

相关考题

单项选择题

Which data organization schemes are supported?（）

A.PARTITION BY HASH and ORGANIZE BY
B.PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE
C.PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE
D.PARTITION BY RANGE and ORGANIZE BY

单项选择题

If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）

A.All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.
B.Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.
C.Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.
D.A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

单项选择题

Which server houses the database partitions in the AIX BCU V2.1? （）

A. IBM System p5 570
B. IBM System p5 575
C. IBM System p5 590
D. IBM System p5 595