Which utility is used to administer SQL Server 2

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

(Continued from previous question...)

Which utility is used to administer SQL Server 2005 Notification Services instances?

Answer
nscontrol.exe

Explanation
The nscontrol application can be used with various parameters to administer a SQL Server 2005 Notification Services instance.

(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?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• When using the SQLCMD tool, what does the -V parameter do?
• Yesterday's QOD How are comments denoted in an XML document?
• Assuming the column name is correct, which of the following is a valid cast operation in SSIS _expression language?
• The queries still seem slow immediately after snapshot creation. Why?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• Which types of replication work with Oracle publishers?
• A certificate is like which type of key in SQL Server 2005 encryption?
• More...