Question 1 : CONTAINS and CONTAINSTABLE look for an _______ match for the phrase.
1. exact
2. similar
3. different
4. none of the mentioned
View Answer   Discuss with Members

Question 2 : The CONTAINS and FREETEXT predicates return a _________ value.
1. TRUE or FALSE
2. Scalar
3. One
4. All of the mentioned
View Answer   Discuss with Members

Question 3 : FREETEXTTABLE is a full text _____________
1. Predicate
2. Function
3. Procedure
4. All of the mentioned
View Answer   Discuss with Members

Question 4 : We can create a full-text index on :
1. table
2. view
3. indexed view
4. all of the mentioned
View Answer   Discuss with Members

Question 5 : Full-text search is an ________ component of the SQL Server Database Engine
1. slower
2. optimal
3. faster
4. none of the mentioned
View Answer   Discuss with Members

Question 6 : Full-Text Search in SQL Server lets users and applications run _________ queries.
1. simple queries
2. full-text
3. scalar
4. none of the mentioned
View Answer   Discuss with Members

Question 7 : Every database you create has which collection by default ?
1. sys
2. sym
3. syx
4. None of the Mentioned
View Answer   Discuss with Members

Question 8 : What is every identifier in an XQuery called ?
1. Name
2. QName
3. Qidt
4. Qnam
View Answer   Discuss with Members

Question 9 : SQL Server provides how many Xquery methods ?
1. 3
2. 4
3. 5
4. 6
View Answer   Discuss with Members

Question 10 : Which of the following function returns an instance of the XML data type ?
1. query()
2. value()
3. nodes()
4. None of the Mentioned
View Answer   Discuss with Members