Which is a restriction on a list partitioned table?()
A. You cannot create global range partitioned indexes on the table.
B. The optimizer will not execute partition wise joins on the table’s partitions.
C. You must include at least one element in the value list of each partition of the table, even if that element is the keyword NUL
D. Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.