单项选择题

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

A.db2advis -d proddb -i workload.sql -P
B.db2advis -d proddb -i workload.sql -partitioning
C.db2advis -d proddb -i workload.sql -m P
D.db2advis -d proddb -i workload.sql -m ALL

点击查看答案

上一题目录下一题

相关考题

单项选择题

A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）

A.one server having at least two processors
B.two servers having one processor and one logical database partition
C.one server having four processors and two logical database partitions
D.two servers each having four processors and two logical database partitions

多项选择题

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