284.Evaluate the following SQL statement used to create the PRODUCTS table:
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.
Answer: D因为分区列是虚拟列,所以值不会物理存储在分区中。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-2121721/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81227/viewspace-2121721/