Next >>
SQL Server 2005 supports four different types of XML indexes.
The primary XML index on an XML column is a clustered index on an internal
table known as the node table. It cannot be used directly from the T-SQL
statements. The primary XML index is a B+tree...............
Read answer
Syntax to create a primary index...........
Read answer
A full text index indexes the entire XML instance and ignores
the values, nodes and other XML syntax. Only one content index is allowed per
table..............
Read answer
Index building avoids parsing the whole data at run time and
benefits index lookups for efficient query processing................
Read answer
A primary index can be created on only one XML data type
column. Primary keys of a table cannot be modified if a primary key exists on a
same table.............
Read answer
Answer - XML data binding refers to the process of representing
the information in an XML document as an object in computer
memory...............
Answer - XML documents can contain non ASCII characters, like
Norwegian æ ø å , or French ê è é which introduce errors...............
Answer - XML Serialization makes it possible to convert any
common language runtime objects into XML documents or streams and vise versa.
..............
Syntax and example for creating and dropping XML schema collection.
Limitations of the XML Schema collections.
Discuss about XML schema collection permission............
Overview of integration of CLR with SQL Server, Advantages of CLR
integration............
|
