PrepAway - Latest Free Exam Questions & Answers

Tag: this causes the fulltext index when searching for the root word an empty resultset

What should you do to include ‘root’ in the query that returned?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which make
use of the Fulltext indexes. However, some of the records have the word ‘root’ in CK_Prod. This
causes the Fulltext index, when searching for the root word, an empty resultset. You need to
include ‘root’ in the query that returned.

What should you do?