Which of the following is not true about the Raw

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

(Continued from previous question...)

Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?

Answer
It supports BLOB object data.
Explanation
The Raw File Destination connection does not use a connection manager, supports NULL data, and only has one input. It also does not support BLOB data or have an error output.

(Continued on next question...)

Other Job Interview Questions

• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• What's an allocation unit?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• In Reporting Services 2005, how is Report Builder typically deployed to end users?
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• What does the NULLIF function do?
• How many of these servers can you consolidate?
• More...