Evaluate the following SQL statement used to create the PRODUCTS table:<br /> <img src="https://img.ppkao.com/2018-08/yiyu/2018080210365762118.jpg" /><br /> Which statement is true regarding this command?()<p> Evaluate the following SQL statement used to create the PRODUCTS table:<br /> <img src="https://img.ppkao.com/2018-08/yiyu/2018080210365762118.jpg" /><br /> Which statement is true regarding this command?()</p>
A、A. It executes successfully but partition pruning cannot happen for this partition key.
B、B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C、C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D、D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.