You are a database developer. You plan to design a database solution by using SQL Server
2008. You have a Web site supported by a database that has the full-text search
component installed. You plan to create a table named Courses that will have the following
structure. Users of the Web site will search for courses based on the CourseTitle field. You
need to construct a full-text query that ensures the following compliances when a user
launches the search for a course: ·Rows are returned when the exact search phrase is
found. ·Rows are in order of how well they match with the search phrase. What should you
specify in the full-text query?

A.
A CONTAINSTABLE function

B.
A FREETEXT predicate

C.
A CONTAINS predicate

D.
A FREETEXTTABLE function

Explanation: