SQL Server XML integration interview questions


SQL Server XML integration interview questions

<<Previous  Next>>

What is Xquery?
What are XML indexes?
What are secondary XML indexes?
What is FOR XML in SQL Server?
What is the OPENXML statement in SQL Server?
How to call stored procedure using HTTP SOAP? 
What is XMLA? 

SQL Server XML integration - March 10, 2009 at 22:00 PM by Rajmeet Ghai

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 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.

What is the OPENXML statement in SQL Server?

OPENXML is a row set provider, in which a row set view over an XML documented is provided. It is used to parse the complex XML function.


OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH (SchemaDeclaration | TableName)]

Idoc is the document handle of an XML document which is created by calling sp_xml_preparedocument

Xpath is the pattern used to identify the nodes.

Flag is for mapping between the XML data and the relational rowset

WITH clause is used to provide a rowset format.

How to call stored procedure using HTTP SOAP?

Stored procedures can be called using HTTP SOAP by creating endpoints. A SOAP endpoint is identified by a URL. Each endpoint supports a protocol, either HTTP OR TCP.

Syntax for Endpoint:

CREATE ENDPOINT name_of_end_point
        PATH = specifies path of the service end point.
        PORTS = (CLEAR),
        SITE = name of the host computer
        WEBMETHOD – name of the web method to be used.
        WSDL = DEFAULT,
        DATABASE = name of the database
        NAMESPACE = specifies a name space for end point.

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.

<<Previous  Next>>

Also read

Describe in brief exporting and importing utility?

Answer - The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database....

Define Distributed Query and Linked Server?

Answer - Distributed Query is a query which can retrieve data from multiple data sources including distributed data........

Define temporary and extended stored procedure.

Answer - Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

Define Primary and Unique key.

Answer - The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table.....

What is index? Define its types.

Answer - Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record.........

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring