Next
>>
Create a table with a untype XML column
CREATE TABLE X
{
[XID] [int] NOT NULL,
[XINFO] [xml] NOT NULL
} ON [PRIMARY]....................
Read answer
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
query() - method to query over an XML instance. value() -
method to retrieve a value of SQL type from an XML instance..................
Read answer
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
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
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
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?..........
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?............
Answer - The term CDATA is used when you dont want some text
data to be parsed by the XML parser. ..............
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...............
Answer -
Xquery is a query language that is used to retrieve data from XML
documents...............
|