Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book
  1. What XML parser does SQL Server's XML features use?

  2. True or false: The NESTED option can be used only in client-side FOR XML.

  3. What extended stored procedure is used to prepare an XML document for use by OPENXML?

  4. What's the theoretical maximum amount of memory that SQLXML will allow MSXML to use from the SQL Server process space?

  5. True or false: There is currently no way to disable template caching for a given SQLISAPI virtual directory.

  6. Describe the use of the sql:mapping attribute from Microsoft's mapping-schema namespace.

  7. 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?

  8. What XML support file must you first define before bulk loading an XML document into a SQL Server database?

  9. What does sql:relationship establish for two tables?

  10. 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?

  11. Explain the way that URL queries are handled by SQLXML.

  12. True or false: You can return traditional rowsets from SQLXMLOLEDB just as you can from any other OLE DB provider.

  13. What Win32 API does SQLXML call in order to compute the amount of physical memory in the machine?

  14. Name the two major APIs that MSXML provides for parsing XML documents.

  15. Approximately how much larger in memory is a DOM document than the underlying XML document?

  16. Describe what a “spec proc” is.

  17. What internal spec proc is responsible for implementing the sp_xml_preparedocument extended procedure?

  18. What two properties must be set on the ADO Command object in order to allow for client-side FOR XML processing?

  19. What method of the ADO Recordset object can persist a recordset as XML?

  20. What does the acronym “SAX” stand for in XML parlance?

  21. When a standard Transact-SQL query is executed via a URL query, what type of event does it come into SQL Server as?

  22. What's the name of the OLE DB provider that implements client-side FOR XML functionality and in what DLL does it reside?

  23. Does SQLXML use MSXML to return XML results from server-side FOR XML queries?

  24. True or false: SQLXML no longer supports XDR schemas.

  25. What component should you use to load XML data into SQL Server in the fastest possible manner?

  26. True or false: SQLISAPI does not support returning non-XML data from SQL Server.

  27. Is it possible to configure a virtual directory such that FOR XML queries are processed on the client side by default?

  28. Approximately how much larger than the actual document is the in-memory representation of an XML document stored by SQLXML for use with OPENXML?

  29. True or false: SQLXML does not support inserting new data via OPENXML because OPENXML returns a read-only rowset.

  30. 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?

  31. Name the central SQL Server error-reporting routine in which we set a breakpoint in this chapter.

  32. Describe a scenario in which it would make sense to use a mapping schema with an updategram.

  33. What lone value can SQLXMLOLEDB's Data Source parameter have?

  34. 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.

  • + Share This
  • 🔖 Save To Your Account