Question 11 : Which of the following function is contained by both full text search and Xquery ?
1. search()
2. contain()
3. contains()
4. query()
View Answer   Discuss with Members

Question 12 : Following content of XML elements are indexed in full text :
1. Content of the XML value
2. Non numerical value in content of XML attributes
3. The content of XML elements.
4. None of the mentioned
View Answer   Discuss with Members

Question 13 : Sample applications to illustrate XML functionality in SQL Server are:
1. Implementing XML in SQL Server
2. XmlOnlineCatalog
3. XmlSurvey
4. All of the mentioned
View Answer   Discuss with Members

Question 14 : Different xml modes available for xml clauses are :
1. RAW
2. AUTO
3. PATH
4. All of the mentioned
View Answer   Discuss with Members

Question 15 : Statement for dropping XML index is :
1. DROP INDEX
2. DELETE INDEX
3. REMOVE INDEX
4. None of the Mentioned
View Answer   Discuss with Members

Question 16 : What is the purpose of primary XML index ?
1. Persisted representation of data
2. Shredded representation of data
3. Structured representation of data
4. None of of the Mentioned
View Answer   Discuss with Members

Question 17 : SQL Server lets you define how many types of secondary XML indexes?
1. 3
2. 4
3. 5
4. 6
View Answer   Discuss with Members

Question 18 : Which of the following indexes can be created on XML columns?
1. Primary
2. Secondary
3. Full-text
4. All of the Mentioned
View Answer   Discuss with Members

Question 19 : Which of the following is not a xml data type method ?
1. query()
2. value()
3. nodes()
4. None of the Mentioned
View Answer   Discuss with Members

Question 20 : SQL Server 2008 has made several extensions to the XML Schema support which includes :
1. Support for lax validation
2. Added support for list and union types
3. Improved handling of xs:time
4. All of the mentioned
View Answer   Discuss with Members