This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Full Text Search”.
1. Full-Text Search in SQL Server lets users and applications run _________ queries.
a) simple queries
b) full-text
c) scalar
d) none of the mentioned
View Answer
Explanation: Before you can run full-text queries on a table, the database administrator must create a full-text index on the table.
2. Point out the correct statement.
a) The full-text index includes only one character-based column in the table
b) The full-text index includes more than one character-based columns in the table
c) The full-text index includes one or more character-based columns in the table
d) None of the mentioned
View Answer
Explanation: Each full-text index indexes one or more columns from the table, and each column can use a specific language.
3. Full-text search is an ________ component of the SQL Server Database Engine.
a) slower
b) optimal
c) faster
d) none of the mentioned
View Answer
Explanation: Full-text queries perform linguistic searches against text data in full-text indexes.
4. We can create a full-text index on _____________
a) table
b) view
c) indexed view
d) all of the mentioned
View Answer
Explanation: Full text index can contain up to 1024 columns.
5. 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
View Answer
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.
6. Full text indexing is a great feature that solves a database problem, the searching of _________ columns for specific words and phrases in SQL Server databases.
a) Textual data
b) Character data
c) String
d) All of the mentioned
View Answer
Explanation: Full Text Index can be used to search words, phrases and multiple forms of word or phrase.
7. Which of the following predicates is used for full text search?
a) TEXT()
b) FREETEXT()
c) TEXT()
d) All of the mentioned
View Answer
Explanation: Full Text Index can be used to search words, phrases and multiple forms of word or phrase using FREETEXT() and CANTAINS() with “and” or “or” operators.
8. FREETEXTTABLE is a full text _____________
a) Predicate
b) Function
c) Procedure
d) All of the mentioned
View Answer
Explanation: FREETEXTTABLE functions are referenced like a regular table name in the FROM clause of a SELECT statement.
9. The CONTAINS and FREETEXT predicates return a _________ value.
a) TRUE or FALSE
b) Scalar
c) One
d) All of the mentioned
View Answer
Explanation: The CONTAINS and FREETEXT predicates return a TRUE or FALSE value. They can be used only to specify selection criteria for determining whether a given row matches the full-text query.
10. CONTAINS and CONTAINSTABLE look for a _______ match for the phrase.
a) exact
b) similar
c) different
d) none of the mentioned
View Answer
Explanation: In full-text search, a word (or token) is a string whose boundaries are identified by appropriate word breakers, following the linguistic rules of the specified language.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Apply for Programming Internship
- Check Information Technology Books
- Check SQL Server Books
- Practice Programming MCQs
