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 the values in the TOTAL_VALUE column would not be
physically stored in the partitions.
B.
It executes successfully but partition pruning cannot happen for this partition key.
C.
It produces an error because the TOTAL_VALUE column cannot be used as a partition
key.
D.
It produces an error because compression cannot be used for the TOTAL_VALUE
partition key.