Question 27


Answer A is correct. Before executing full-text searches, you must create and populate a full-text catalog. Population usually occurs when the catalog is created. A full-text catalog is the basis of the storage used for indexes. These catalogs should periodically be repopulated to ensure usefulness. Repopulation can be done by schedule or by administrative task.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects," and Chapter 3, "Implementing Database Objects"

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

  • "SQL Server 2005 full-text search includes improved and updated noise word files," http://support.microsoft.com/default.aspx?scid=kb;en-us;905617

  • Within MSDN Library, go to MSDN Home, SQL Server Developer Center, Community, Webcasts, Full-Text Search Q and A.




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