You have a table named Books that has columns named BookTitle and Description. There is a full-text index on these columns. You need to return rows from the table in which the word ‘computer’ exists in either column. Which code segment should you use?
A.
SELECT * FROM Books
WHERE FREETEXT(*,’computer’)
B.
SELECT * FROM Books
WHERE BookTitle LIKE ‘%computer%’
C.
SELECT * FROM Books
WHERE BookTitle = ‘%computer%’
OR Description = ‘%computer%’
D.
SELECT * FROM Books
WHERE FREETEXT(BookTitle,’computer’)