adplus-dvertising
frame-decoration

Question

Statement for dropping XML index is __________

a.

DROP INDEX

b.

DELETE INDEX

c.

REMOVE INDEX

d.

None of the Mentioned

Answer: (a).DROP INDEX

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Statement for dropping XML index is __________

Similar Questions

Discover Related MCQs

Q. Different xml modes available for xml clauses are __________

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

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

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

Q. Point out the correct statement.

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

Q. SQL Server provides how many Xquery methods?

Q. Point out the correct statement.

Q. What is every identifier in an XQuery called?

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

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

Q. Functions on numerical values in Xquery are ___________

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

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

Q. Why do we use exist methods in Xquery?

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

Q. Point out the correct statement.

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

Q. We can create a full-text index on _____________

Q. Point out the wrong statement.