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

• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• Clicking File, Save in Report Builder does which of the following?
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• Which key provides the strongest encryption?
• No column permissions are assigned. What should you do?
• Which of the following is an invalid file name for a database file?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• Which utility is used to administer SQL Server 2005 Notification Services instances?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• More...