Which code segment should you use?

You have a table named Books that has columns named BookTitle and Description. There is a fulltext
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?

You have a table named Books that has columns named BookTitle and Description. There is a fulltext
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’)



Leave a Reply 0

Your email address will not be published. Required fields are marked *