Which of the following predicates is used for full text search ?
A. TEXT()
B. FREETEXT()
C. TEXT()
D. All of the mentioned
Answer:A
Which of the following predicates is used for full text search ?
A. TEXT() B. FREETEXT() C. TEXT() D. All of the mentioned
Explanation:Full Text Index can be used to search words, phrases and multiple forms of word or phrase using FREETEXT() and CANTAINS() with “and” or “or” operators.