Oracle 11G OCP 1Z0-053 284

（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.

答案：（D）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1270912/，如需轉載，請註明出處，否則將追究法律責任。