Knowledge Measure

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

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial