Which statement is true regarding this command?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *