You intend to use SQL Server 2008 to create a database solution. The full-text search component is installed in the database which supports a Web site.
You intend to create a table named Courses which has the structure above. On the basis of the CourseTitle field, users of the Web site will search for courses. When the search is launched for a course by a user, a full-text must be constructed to ensure the compliances below:
* when the exact search phrase is found, rows are returned;
* rows are in order of how well they match with the search phrase.
So what should you specify in the full-text query?
A.
A CONTAINS predicate
B.
A FREETEXT predicate
C.
A CONTAINSTABLE function
D.
A FREETEXTTABLE function
Explanation:
CONTAINSTABLE (Transact-SQL)
Returns a table of zero, one, or more rows for those columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases, the proximity of words within a certain distance of one another, or weighted matches. CONTAINSTABLE can only be referenced in the FROM clause of a SELECT statement as if it were a regular table name. Queries using CONTAINSTABLE specify contains-type full-text queries that return a relevance ranking value (RANK) and full-text key (KEY) for each row. The CONTAINSTABLE function uses the same search conditions as the CONTAINS predicate.