Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 9
1. Full-Text Search in SQL Server lets users and applications run _________ queries.
Correct Answer is : full-text
2. Point out the correct statement :
Correct Answer is : The full-text index includes one or more character-based columns in the table
3. Full-text search is an ________ component of the SQL Server Database Engine
Correct Answer is : optimal
4. We can create a full-text index on :
Correct Answer is : all of the mentioned
5. Point out the wrong statement :
Correct Answer is : Full-text search is applicable to a shorter range of business scenarios
6. Which of the following predicates is used for full text search ?
Correct Answer is : FREETEXT()
7. FREETEXTTABLE is a full text _____________
Correct Answer is : Function
8. The CONTAINS and FREETEXT predicates return a _________ value.
Correct Answer is : TRUE or FALSE
9. CONTAINS and CONTAINSTABLE look for an _______ match for the phrase.
Correct Answer is : exact
