单选题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

第1题：

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

第2题：

Which is a restriction on a list partitioned table？（）

• A、You cannot create global range partitioned indexes on the table. 
• B、The optimizer will not execute partition wise joins on the table’s partitions. 
• C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. 
• D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

第3题：

Which of the following explains the relationship between a physical and logical partition?（）

• A、A physical partition is hosted on one or more logical partitions. A logical partition is used when describing storage.
• B、A logical partition is hosted on one or more physical partitions. A physical partition is used when describing storage.
• C、A physical partition is used when describing only a SCSI or SAS disk. A logical partition is used when describing a SAN LUN.
• D、A logical partition is used when describing only a SATA or SAS disk. A physical partition is used when describing RAID or mirrored arrays.

第4题：

In which cases is reference partitioning effective in enhancing performance?（）

• A、It is effective only in partition pruning.
• B、It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
• C、It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
• D、It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

第5题：

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

• A、A syntax error will result as you cannot specify more than one partition in the same statement
• B、All data in p1 and p3 partitions are removed and the table definition is changed
• C、All data in p1 and p3 partitions are removed, but the table definition remains unchanged
• D、Only the first partition (p1) will be dropped as only one can be dropped at any time

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））  AS SELECT * FROM purchases WHERE time_id < TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；   What is the outcome of the above command？（）  

• A、 It returns an error because the range partitions P1 and P2 should be of the same range.
• B、 It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.
• C、 It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.
• D、 It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.

第14题：

After purchasing the Active Memory Expansion （AME） Enablement Feature，what tasks must be completed before AME can be used？（）

• A、Enable using active partition properties with DLPAR
• B、Enter the activation key via the AIX 6.1 command line and reboot AIX
• C、Enter the activation key via the HMC,power cycle the managed system and start the LPAR
• D、Enter the activation key via the HMC,modify the partition profile and restart the LPAR

第15题：

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.

第16题：

Which statements are true regarding system-partitioned tables？（）  

• A、 Only a single partitioning key column can be specified.
• B、 All DML statements must use partition-extended syntax.
• C、 The same physical attributes must be specified for each partition.
• D、 Unique local indexes cannot be created on a system-partitioned table.
• E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

第17题：

Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

• A、 It executes successfully but partition pruning cannot happen for this partition key.
• B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
• C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
• D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：