Explanation:The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity. 4. 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
Answer:A
Explanation:The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity. 4. 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