Which severity levels of errors can be corrected

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

(Continued from previous question...)

Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)

Answer
11-16

Explanation
Severity levels 11-16 are correctable by users. Below 11, these are informational warnings and not raised as system errors. Errors above 16 must have an administrator or Microsoft correct.

(Continued on next question...)

Other Job Interview Questions

• What's SQL Server
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• A certificate is like which type of key in SQL Server 2005 encryption?
• What type of update did you perform?
• Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• Which table would you query in your report to get logging information about a job step?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• How can you easily monitor to see if this assembly is being used?
• Which of the following statements best describes the filter capabilities of Report Builder?
• More...