Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 10
1. Which of the following is not a xml data type method ?
Correct Answer is : None of the Mentioned
2. Which of the following indexes can be created on XML columns?
Correct Answer is : All of the Mentioned
3. SQL Server lets you define how many types of secondary XML indexes?
Correct Answer is : 3
4. What is the purpose of primary XML index ?
Correct Answer is : None of of the Mentioned
5. Statement for dropping XML index is :
Correct Answer is : DROP INDEX
6. Different xml modes available for xml clauses are :
Correct Answer is : All of the mentioned
7. Sample applications to illustrate XML functionality in SQL Server are:
Correct Answer is : All of the mentioned
8. Following content of XML elements are indexed in full text :
Correct Answer is : Non numerical value in content of XML attributes
9. Which of the following function is contained by both full text search and Xquery ?
Correct Answer is : contains()
10. Point out the correct statement :
Correct Answer is : The option DROP_EXISTING is permitted in the ALTER INDEX statement
