Loading...

SQL Server

SQL Server provides how many Xquery methods
  1. 3
  2. 4
  3. 5
  4. 6
Point out the correct statement
  1. XQuery statements are case sensitive and xml is case sensitive
  2. XQuery statements are case insensitive and xml is case insensitive
  3. XQuery statements are case sensitive and xml is case insensitive
  4. XQuery statements are case insensitive since xml is case sensitive
What is every identifier in an XQuery called
  1. Name
  2. QName
  3. Qidt
  4. Qnam
Every database you create has which collection by default
  1. sys
  2. sym
  3. syx
  4. None of the Mentioned
Different types of errors raised during Xquery operation are
  1. Static
  2. Dynamic
  3. Type
  4. All of the mentioned
Functions on numerical values in Xquery are
  1. ceiling
  2. concat
  3. contains
  4. number
Atomization is process of extracting ________ value of an item
  1. XML value
  2. Non numercial value
  3. Typed
  4. None of the mentioned
With XML DML,which of the operations can be performed on nodes
  1. Insert nodes
  2. Change nodes
  3. Delete nodes
  4. None of the mentioned
Why do we use exist method in Xquery
  1. To determine if the XML data contains a certain node
  2. To examine the XML and return back a scalar value
  3. To Shred the XML nodes of the XML data into relational columns
  4. To search inside xml data types
Full-Text Search in SQL Server lets users and applications run _________ queries
  1. simple queries
  2. full-text
  3. scalar
  4. none of the mentioned