Microsoft
70-433 · Question #138
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…
The correct answer is C. ALTER FULLTEXT INDEX ON ftInventory. See the full explanation below for the reasoning.
Question
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?
Options
- AALTER FULLTEXT INDEX ON ftInventory
- BALTER FULLTEXT INDEX ON ftInventory
- CALTER FULLTEXT INDEX ON ftInventory
- DALTER FULLTEXT CATALOG ftCatalog REBUILD
How the community answered
(50 responses)- A4% (2)
- B16% (8)
- C72% (36)
- D8% (4)
Community Discussion
No community discussion yet for this question.