You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_Prod which make use
of the Fulltext indexes.
One day ABC.com users complain that some searches in the database is not working any longer.
In particular, some searches result an empty resultsets, even though even though the
corresponding key words are indeed present in the database.
What action should you take to resolve this problem?
A.
You should consider adding a new full-text index.
B.
You should consider changing the full-text index.
C.
You should consider repearing the full-text index.
D.
You should consider stop and start the MSFTESQL service.
E.
You should consider deleting the full-text catalog and rebuild it.
F.
Add the appropriate key words to the Fulltext index.
Explanation: