+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

SQL Server XML Iintegration Interview Questions and Answers

What is Xquery?

Xquery is used to query XML data. This may be either a database or a file. It used xpath expressions that can be used to extract elements and attributes from XML documents.

What is XMLA?

XML for Analysis facilitates communication of client applications with OLAP data sources. Communication is done via XML, HTTP, or SOAP. XMLA open standards support data access to data sources on the WWW.

What are XML indexes?

XML indexes are created on XML data type columns. Having XML indexes will reduce cost with respect to maintenance and data modification. Use of XML indexes avoids the need to parse the complete data at runtime thereby increasing query processing efficiency.

What are secondary XML indexes?

XML indexes can either be primary or secondary. When the XML type column has its first index, it is called as a primary index. Using this primary index, secondary indexes like PATH, VALUE and PROPERTY are supported. Depending on the nature of queries, they help in query optimization.

Path secondary index if used speeds up queries if the query specifies a path.

Path secondary index if used speeds up queries are value based.

Path secondary index if used speeds up queries if the query retrieves one or more values from individual XML instances.

What is FOR XML in SQL Server?

FOR XML allows data to be retrieved in an XML format. The FOR XML clause needs to be mentioned at the end of SELECT statement. There are three modes of FOR XML:-

RAW mode: - An XML element is formed for each row in the query results.

AUTO mode: - The query results are returned as nested XML elements.

Explicit mode: - the format of the XML document returned by the query can be completely controlled by the query.

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.