Which statement is true about an index that is used to support a UNIQUE constraint?
A. It must not contain more than one column.
B. It cannot be used in a referential constraint.
C. It must be defined with the UNIQUE attribute.
D. It must be defined as UNIQUE WHERE NOT NULL.