JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Firm
Full Text Search interview questions
Full Text Search interview questions
Back
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.
A. simple queries
B. full-text
C. scalar
D. none of the mentioned
Show Correct Answer
Correct Answer is :
full-text
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
Show Correct Answer
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
A. slower
B. optimal
C. faster
D. none of the mentioned
Show Correct Answer
Correct Answer is :
optimal
4. We can create a full-text index on :
A. table
B. view
C. indexed view
D. all of the mentioned
Show Correct Answer
Correct Answer is :
all of the mentioned
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
Show Correct Answer
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 ?
A. TEXT()
B. FREETEXT()
C. TEXT()
D. All of the mentioned
Show Correct Answer
Correct Answer is :
FREETEXT()
7. FREETEXTTABLE is a full text _____________
A. Predicate
B. Function
C. Procedure
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Function
8. The CONTAINS and FREETEXT predicates return a _________ value.
A. TRUE or FALSE
B. Scalar
C. One
D. All of the mentioned
Show Correct Answer
Correct Answer is :
TRUE or FALSE
9. CONTAINS and CONTAINSTABLE look for an _______ match for the phrase.
A. exact
B. similar
C. different
D. none of the mentioned
Show Correct Answer
Correct Answer is :
exact
Similar Interview Questions
Search for latest jobs
Find Jobs