Which optional SQL Server component must you ins

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

(Continued from previous question...)

Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?

Answer
SQL Server Integration Services

Explanation
You must install Integration Services in order to properly create and execute maintance plans since these plans are a subset of SSIS packages.

(Continued on next question...)

Other Job Interview Questions

• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• What does VARP() do in SQL Server 2005?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• How can you quickly determine if any of these indexes are really being used?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• What is an example of hardware partitioning?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• What does the NULLIF function do?
• More...