Which of these options cannot be set in the SQL

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

(Continued from previous question...)

Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?

Answer: Process all data as Unicode.

Explanation: You can set all of the options given except the Unicode option.

(Continued on next question...)

Other Job Interview Questions

• A certificate is like which type of key in SQL Server 2005 encryption?
• What type of update did you perform?
• What does REVERT do in SQL Server 2005?
• In SQL Server 2005, what is the maximum size of an index key?
• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• More...