More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
Answer: Determines if space is left at the intermediate pages of indexes.
Explanation: If PAD_INDEX is set to ON, then the fillfactor is used to determine how much space is left in the intermediate pages of an index. If set to OFF, then the intermediate pages are filled near their limit with space being left for at least one row.
(Continued on next question...)