DBI202Xuất hiện trong 1 đề thi
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 SQL code segment should you use?
Các lựa chọn
ASELECT * FROM Books WHERE FREETEXT(*,'computer')
BSELECT * FROM Books WHERE BookTitle LIKE '%computer%'
CSELECT * FROM Books WHERE BookTitle = '%computer%' OR Description = '%computer%'
DSELECT * FROM Books WHERE FREETEXT(BookTitle,'computer')