Explanation:The XML data type comes with four methods that assist with querying and manipulating the XML data stored in the column or variable. Those methods are query(), value(), nodes() and modify(). 2. Which of the following indexes can be created on XML columns?
A. Primary
B. Secondary
C. Full-text
D. All of the Mentioned
Answer:A
Explanation:The XML data type comes with four methods that assist with querying and manipulating the XML data stored in the column or variable. Those methods are query(), value(), nodes() and modify(). 2. Which of the following indexes can be created on XML columns?
A. Primary B. Secondary C. Full-text D. All of the Mentioned
Explanation:You can also create full-text indexes on XML columns. However, the indexes ignore the XML markup and include only element content.