1Z0-053 V13.02 Q284

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/