When you declare an XML variable in SQL Server 2

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

(Continued from previous question...)

When you declare an XML variable in SQL Server 2005, what are the two types of typed XML data. What are they?

Answer: CONTENT and DOCUMENT
Explanation: The two types you can declare are CONTENT and DOCUMENT.

(Continued on next question...)

Other Job Interview Questions

• What feature of SQL Server 2005 would help you get the snapshot transferred?
• SELECT USER_NAME() -- Returns Andy
• You want to disable the trigger dEmployee on the HumanResources...
• Where can you view the list of server-scoped DDL triggers?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• What does the DUMP command do?
• What type of connectivity does the readpipe/makepipe utility test?
• How many rows are returned by these two select statements?
• What does the tablediff utility do?
• Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
• More...