CREATE TABLE products ( product_id NUMBER(3) PRIMARY KEY, product_desc VARCHAR2(25), qty NUMBER(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.
答案:(D)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1270912/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1270912/