Q. What is the purpose of the primary XML index?

View solution

Q. Statement for dropping XML index is __________

View solution

Q. Different xml modes available for xml clauses are __________

View solution

Q. Sample applications to illustrate XML functionality in SQL Server are _____________

View solution

Q. Following content of XML elements are indexed in full text?

View solution

Q. Which of the following function is contained by both full text search and Xquery?

View solution

Q. Point out the correct statement.

View solution

Q. Which of the following function returns an instance of the XML data type?

View solution

Q. SQL Server provides how many Xquery methods?

View solution

Q. Point out the correct statement.

View solution

Q. What is every identifier in an XQuery called?

View solution

Q. Every database you create has which collection by default?

View solution

Q. Different types of errors raised during Xquery operation are ______________

View solution

Q. Functions on numerical values in Xquery are ___________

View solution

Q. Atomization is process of extracting ________ value of an item.

View solution

Q. With XML DML, which of the operations can be performed on nodes?

View solution

Q. Why do we use exist methods in Xquery?

View solution

Q. Full-Text Search in SQL Server lets users and applications run _________ queries.

View solution

Q. Point out the correct statement.

View solution

Q. Full-text search is an ________ component of the SQL Server Database Engine.

View solution