Which of the following guideline is considered during column design?

• A. Keep the length of the index key short for non clustered indexes
• B. An xml data type can only be a key column only in an XML index
• C. Examine column which have composite primary keys
• D. None of the mentioned