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: