Which type of XML variable requires a\one and on

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

(Continued from previous question...)

Which type of XML variable requires a\one and only one root element?

Answer: DOCUMENT

Explanation: The DOCUMENT XML data requires that there be one and only one root element. The CONTENT type allows multiple elements at the top level.

(Continued on next question...)

Other Job Interview Questions

• You want to disable the trigger dEmployee on the HumanResources...
• True or false, Report Builder supports using the LIKE function inside filters?
• How many Service Packs will be released for SQL Server 2005 in 2007?
• The TRUSTWORTHY database property is by default?
• True or false, Report Builder supports using the LIKE function inside filters?
• Where are Notification Services event messages logged in SQL Server 2005?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• A certificate is like which type of key in SQL Server 2005 encryption?
• In SQL Server 2005, what is the maximum size of an index key?
• In Full-Text Search, what is word breaking?
• More...