Question 30

Answers B and C are correct. To implement full-text indexes, you need a catalog to store the indexes and an index defined for the text columns in which searches are going to be performed. Other index implementation is irrelevant to the implementation of full-text indexing.

For more information, see the following sources:

• Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "Full-Text Search"