DBA > Job Interview Questions > Microsoft SQL Server FAQs

For regulatory reasons, you must maintain an exa

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

(Continued from previous question...)

For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?

Answer
varchar(max)

Explanation
The XML data type changes the representation of your XML document into an internal, optimized version that has all the content, but may not maintain the original text. The varchar(max) or nvarchar(max) represenations should be used in this case.

(Continued on next question...)

Other Job Interview Questions