Multiple choice technology databases

What types of indexes are supported by SQL Server 2005?

  1. Clustered and non clustered

  2. Unique

  3. XML index

  4. All the Above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL Server 2005 supports clustered and non-clustered indexes, unique constraints (which are enforced via unique indexes), and introduced XML indexes for querying XML data type columns. Hence, all of these index types are supported by SQL Server 2005.