Which database holds the tables that Database Ma

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

(Continued from previous question...)

Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?

Answer: msdb

Explanation: The messaging objects, including tables, are stored in the msdb database.

(Continued on next question...)

Other Job Interview Questions

• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• How many rows are returned by these two select statements?
• Which of the following is not an allocation unit in SQL Server 2005?
• Where are Notification Services event messages logged in SQL Server 2005?
• A certificate is which type of security mechanism?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• What happens when a transaction fails on the publisher?
• More...