Kizspy | Question: 33 (Choose 1 answer)
You have a table named Books that has columns named Book Title 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 Book Title LIKE '%computer%'
C. SELECT * FROM Books WHERE Book Title = '%computer%' OR Description = '%computer%'
D. SELECT * FROM Books WHERE FREETEXT(Book Title, 'computer')
