XML Data type implementation in SQL Server 2005

          

XML Data type implementation in SQL Server 2005

Next >>
Create a table with a untype XML column. Insert into an untyped XML data type column

Create a table with a untype XML column

CREATE TABLE X
{
         [XID] [int] NOT NULL,
         [XINFO] [xml] NOT NULL
} ON [PRIMARY]....................
Read answer

What is typed XML?

Typed XML columns, parameters, and variables can store XML documents or content which need to be specified at the time of declaration with a flag whether you are storing a document or content...............
Read answer

The XML data type comes with five methods. Explain them

query() - method to query over an XML instance. value() - method to retrieve a value of SQL type from an XML instance..................
Read answer

Differentiate between Untyped XML and Typed XML.

Untyped XML - To be used when schema is not available for an for XML data, To be used when data has to be validated on the client side.................
Read answer

Explain with an example how to apply defaults constraint to an XML data type column.

An xml column type can be assigned a default XML instance in a table. It can be done in 2 ways: 1.by using an XML constant..................
Read answer

You can add constraints to XML data type columns. Illustrate with an example.

Constraints can be specified for typed or untyped xml data type columns. However, you cannot use the XML data type methods when you specify constraints.................
Read answer

Next >>
Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?..........

XML Data type implementation in SQL Server 2005

What is Untyped XML?
Provide examples for : Create a table with a untype XML column, Insert into an untyped XML data type column
What is typed XML?............

What is a CDATA section in XML?

Answer - The term CDATA is used when you dont want some text data to be parsed by the XML parser. ..............

What is XSL?

Answer - XSL is a language for expressing style sheets. An XSL style sheet is a file that describes the way to display an XML document...............

What is XQuery?

Answer - Xquery is a query language that is used to retrieve data from XML documents...............



Write your comment - Share Knowledge and Experience


 
Latest placement tests
Latest links
 
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