Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?
Posted: Sun Jun 11, 2023 3:50 pm
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_VLAUE column would not be physically stored in the partitions
- Evaluate The Fo 1 (3.41 KiB) Viewed 247 times
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_VLAUE column would not be physically stored in the partitions