單項(xiàng)選擇題

Evaluate the following SQL statement used to create the PRODUCTS table:

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.

微信掃碼免費(fèi)搜題