Question

Point out the wrong statement.

(a) To define full-text searches, SQL Server full-text queries use the full-text predicates

(b) Full-text queries perform linguistic searches against text data

(c) Before you can run full-text queries on a table, the database administrator must create a full-text index on the table

(d) Full-text search is applicable to a shorter range of business scenarios

This question was posed to me in final exam.

Enquiry is from Full Text Search in section Beyond Relational of SQL Server

Answer 1

Right option is (d) Full-text search is applicable to a shorter range of business scenarios

Explanation: Full-text search is applicable to a wide range of business scenarios such as e-businesses—searching for items on a web site; law firms—searching for case histories in a legal-data repository; or human resources departments—matching job descriptions with stored resumes.