Your company manufactures and distributes bowling balls. You have a fulltext
catalog named
ftCatalog which contains the ftInventory index on the Products table. Your marketing department
has just
inserted a new bowling ball into the Inventory table. You notice only the new bowling ball is not
being
included in the results of the fulltext
searches. You have confirmed that the row exists in the Products
table. You need to update the fulltext
catalog in the least amount of time.
Which TransactSQL
statement should you use?
A.
ALTER FULLTEXT INDEX ON ftInventory
START FULL POPULATION
B.
ALTER FULLTEXT INDEX ON ftInventory
RESUME POPULATION
C.
ALTER FULLTEXT INDEX ON ftInventory
START UPDATE POPULATION
D.
ALTER FULLTEXT CATALOG ftCatalog REBUILD