This chapter is from the book
This chapter is from the book
This chapter is from the book
-
What XML parser does SQL Server's XML features use?
-
True or false: The NESTED option can be used only in client-side FOR XML.
-
What extended stored procedure is used to prepare an XML document for use by OPENXML?
-
What's the theoretical maximum amount of memory that SQLXML will allow MSXML to use from the SQL Server process space?
-
True or false: There is currently no way to disable template caching for a given SQLISAPI virtual directory.
-
Describe the use of the sql:mapping attribute from Microsoft's mapping-schema namespace.
-
Why is the maximum mentioned in question 4 only a theoretical maximum? What other factors could prevent MSXML from reaching its maximum memory allocation ceiling?
-
What XML support file must you first define before bulk loading an XML document into a SQL Server database?
-
What does sql:relationship establish for two tables?
-
Is it possible to change the name of the ISAPI extension DLL associated with a given virtual directory, or must all SQLISAPI-configured virtual directories use the same ISAPI extension?
-
Explain the way that URL queries are handled by SQLXML.
-
True or false: You can return traditional rowsets from SQLXMLOLEDB just as you can from any other OLE DB provider.
-
What Win32 API does SQLXML call in order to compute the amount of physical memory in the machine?
-
Name the two major APIs that MSXML provides for parsing XML documents.
-
Approximately how much larger in memory is a DOM document than the underlying XML document?
-
Describe what a “spec proc” is.
-
What internal spec proc is responsible for implementing the sp_xml_preparedocument extended procedure?
-
What two properties must be set on the ADO Command object in order to allow for client-side FOR XML processing?
-
What method of the ADO Recordset object can persist a recordset as XML?
-
What does the acronym “SAX” stand for in XML parlance?
-
When a standard Transact-SQL query is executed via a URL query, what type of event does it come into SQL Server as?
-
What's the name of the OLE DB provider that implements client-side FOR XML functionality and in what DLL does it reside?
-
Does SQLXML use MSXML to return XML results from server-side FOR XML queries?
-
True or false: SQLXML no longer supports XDR schemas.
-
What component should you use to load XML data into SQL Server in the fastest possible manner?
-
True or false: SQLISAPI does not support returning non-XML data from SQL Server.
-
Is it possible to configure a virtual directory such that FOR XML queries are processed on the client side by default?
-
Approximately how much larger than the actual document is the in-memory representation of an XML document stored by SQLXML for use with OPENXML?
-
True or false: SQLXML does not support inserting new data via OPENXML because OPENXML returns a read-only rowset.
-
What mapping-schema notational attribute should you use with the xsd:relationship attribute if you are using a mapping schema with an updategram and the mapping schema relates two tables in reverse order?
-
Name the central SQL Server error-reporting routine in which we set a breakpoint in this chapter.
-
Describe a scenario in which it would make sense to use a mapping schema with an updategram.
-
What lone value can SQLXMLOLEDB's Data Source parameter have?
-
True or false: The SAX parser is built around the notion of persisting a document in memory in a tree structure so that it is readily accessible to the rest of the application.