Why is the correct answer 4?
I count 7 types of indexes:
clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.
See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.
Even in the explanation given I count more than 4.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP