You need to find all matches from your Product table in which the Description column includes either the words “book” or “booklet”. Which of the following FTS syntaxes should you use?
Select Answer:
FREETEXT(Description, ‘“Book”’)
FREETEXT(Description, ‘“Book*”’)
CONTAINS(Description, ‘“Book”’)
CONTAINS(Description, ‘“Book*”’)
Question Source: MCTS EXAM
|