Evaluate the following SQL statement used reate 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 produces an error because compression cannot be used for the TOTAL_VALUE
partition key.
B.
It executes successfully but the values in the TOTAL_VALUE column would not be
physically stored in the partitions.
C.
It produces an error because the TOTAL_VALUE column cannot be used as a partition
key.
D.
It executes successfully but partition pruning cannot happen for this partition key.
Just desire to say your article is as surprising. The clarity in your post is simply excellent and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please carry on the gratifying work.|