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 FREETEXT (*, ‘cycle’))
B.
SELECT * FROM Inventory
WHERE CONTAINS (*, ‘cycle’)
C.
SELECT * FROM Inventory
WHERE Description LIKE ‘%cycle%’
D.
SELECT * FROM Inventory
WHERE CONTAINS (*, ‘FormsOf(Inflectional, cycle)’)