Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns.
You also use a full-text thesaurus to expand common bicycle terms.
You need to write a full-text query that will not only match the exact word in the search, but also the meaning.
Which Transact-SQL statement should you use?
A. SELECT * FROM Inventory WHERE Description LIKE ‘%cycle%’
B. SELECT * FROM Inventory WHERE FREETEXT (*, ‘cycle’)
C. SELECT * FROM Inventory WHERE CONTAINS (*, ‘FormsOf(Inflectional, cycle)’)
D. SELECT * FROM Inventory WHERE CONTAINS (*, ‘cycle’)
