You are configuring a SQL Server 2005 Reporting

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

(Continued from previous question...)

You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?

Answer: Local or Remote SMTP servers.

Explanation: Rports can be delivered using local or remote SMTP servers.

(Continued on next question...)

Other Job Interview Questions

• What is the best way to have your junior DBA do this?
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• What message types exist in SQL Server 2005 Service Broker?
• How many credentials can one login be mapped to?
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• What's SQL Server
• What rights does a user need to perform a truncate table command SQL Server 2005?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• How secure are encrypted stored procedures, triggers and views?
• More...