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?

Question

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?

Accepted Answer

D. A CONTAINSTABLE function

Answer

A. A FREETEXT predicate

Answer

B. A CONTAINS predicate

Answer

C. A FREETEXTTABLE function

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…

Question

Options

How the community answered

Community Discussion