When declaring an XML document, which type allow

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

When declaring an XML document, which type allows text nodes at the top level?

Answer: CONTENT
Explanation: The CONTENT XML variable declaration allows txt nodes at the top level. This is the default behavior.

(Continued on next question...)

Other Job Interview Questions

• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• Which of the following choices show the three report formats supported by Report Builder
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• What security role should you assign them?
• You need to remove a large table from your database ...
• How can you easily monitor to see if this assembly is being used?
• How does a differential backup know which extents have changed so that it can be very quickly run?
• More...