Your company manufactures and distributes bicycle parts. You have a fulltext
catalog on the
Inventory table which contains the PartName and Description columns. You also use a fulltext
thesaurus
to expand common bicycle terms. You need to write a fulltext
query that will not only match the exact
word in the search, but also the meaning.
Which TransactSQL
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)’)