Microsoft
70-433 · Question #137
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…
The correct answer is A. SELECT * FROM Inventory. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT * FROM Inventory
- BSELECT * FROM Inventory
- CSELECT * FROM Inventory
- DSELECT * FROM Inventory
How the community answered
(55 responses)- A84% (46)
- B5% (3)
- C9% (5)
- D2% (1)
Community Discussion
No community discussion yet for this question.