Loading...

SQL Server

Which of the following indexes can be created on XML columns
  1. Primary
  2. Secondary
  3. Full-text
  4. All of the Mentioned
SQL Server lets you define how many types of secondary XML indexes
  1. 3
  2. 4
  3. 5
  4. 6
What is the purpose of primary XML index
  1. Persisted representation of data
  2. Shredded representation of data
  3. Structured representaion of data
  4. None of of the Mentioned
Statement for dropping XML index is
  1. DROP INDEX
  2. DELETE INDEX
  3. REMOVE INDEX
  4. None of the Mentioned
Different xml modes available for xml clauses are
  1. RAW
  2. AUTO
  3. PATH
  4. All of the mentioned
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
Following content of XML elements are indexed in full text
  1. Content of the XML value
  2. Non numercial value in content of XML attributes
  3. The content of XML elements
  4. None of the mentioned
Which of the following function is contained by both full text search and Xquery
  1. search()
  2. contain()
  3. contains()
  4. query()
Point out the correct statement
  1. If ALTER INDEX ALL is specified, it applies to both non-XML and XML indexes
  2. The rebuild and set option IGNORE_DUP_KEY is not valid for XML indexes
  3. The option DROP_EXISTING is permitted in the ALTER INDEX statement
  4. The modifications of the primary key constraint in the user table are not automatically propagated to XML indexes
Which of the following function returns an instance of the XML data type
  1. query()
  2. value()
  3. nodes()
  4. None of the Mentioned