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 BookTitle LIKE ‘%computer%’
B. SELECT * FROM Books WHERE BookTitle = ‘%computer%’ OR Description = ‘%computer%’
C. SELECT * FROM Books WHERE FREETEXT(BookTitle,’computer’)
D. SELECT * FROM Books WHERE FREETEXT(*,’computer’)
