XML Attributes interview questions
The attributes in XML provide additional information about elements. Take a
look at the following example:...............
Read answer
XML elements as well as attributes can be used to provide the
same information about an entity in an XML database. The only difference lies
in the way they are written. For example:................
Read
answer
It is preferred storing the data using the XML elemental form
as it becomes very convenient to access and modify the data................
Read answer
Also read
XPath is a language for addressing an XML document's elements and attributes. As
an example, say you receive an XML document that contains the details of a
shipment and you want to retrieve the element/attribute values from the XML
document.........
Define DTD
(Document Type definition).
Answer - XML DTD is a rule book that an XML document follows.
Once DTD is ready, you can create number of XML documents following the same
rules..............
What is DOM?
Answer - DOM is an interface-oriented Application Programming
Interface. It allows for navigation of the entire
document...............
What is an
XML encoding error?
Answer - XML documents can contain non ASCII characters, like
Norwegian æ ø å , or French ê è é which introduce
errors...............
What
are XML indexes and secondary XML indexes?
Answer - The primary XML index is a B+tree and is useful
because the optimizer creates a plan for the entire query. ..............
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 Schemas in SQL Server 2005
Syntax and example for creating and dropping XML schema collection.
Limitations of the XML Schema collections.
Discuss about XML schema collection permission.
|