Which Transact-SQL statement should you use?

Your company manufactures and distributes bowling balls. You have a full-text 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 full-text searches. You have confirmed that the row exists in the Products table. You need to update the full-text catalog in the least amount of time. Which Transact-SQL statement should you use?

Your company manufactures and distributes bowling balls. You have a full-text 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 full-text searches. You have confirmed that the row exists in the Products table. You need to update the full-text catalog in the least amount of time. Which Transact-SQL 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



Leave a Reply 0

Your email address will not be published. Required fields are marked *