Question 13


Answer B is correct. You must create a full-text index on the columns you would like to utilize. There is already going to be a catalog in place that can be used because similar functionality exists elsewhere in the database. There must also be a unique column identified in the table. No other forms of indexing will help in this scenario.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

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

  • "Breaking Changes to Full-Text Search in SQL Server 2005," http://msdn2.microsoft.com/en-us/library/ms143709(SQL.90).aspx




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net