Which statement is true regarding this command?

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

Which statement is true regarding this command?

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



Leave a Reply 0

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