What is the default type of XML data if you do n

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

(Continued from previous question...)

What is the default type of XML data if you do not specify an arguement?

Answer: CONTENT
Explanation: The default type of ata is the CONTENT data type, which can have multiple zero or more elements at the top level and contain text nodes at the top level.

(Continued on next question...)

Other Job Interview Questions

• The Service Broker operates on messages in which fashion?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• Using Report Builder, which of the following statements is correct about formatting numbers?
• What does the SQL Writer service do?
• Where is varchar(max) data stored?
• In SQL Server 2005, which network protocols use endpoints?
• Which of the following choices show the three report formats supported by Report Builder
• What does the tablediff utility do?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• More...