Credentials in SQL Server 2005 are used to acces

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

(Continued from previous question...)

Credentials in SQL Server 2005 are used to access what?

Answer
Resources outside the SQL Server

Explanation
A credential is used to access resources outside of SQL Server. It contains the authentication information needed for accessing these resources.

(Continued on next question...)

Other Job Interview Questions

• 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?
• What is the scope of the control permission in SQL Server 2005?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• 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?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• Which key does the OPEN MASTER KEY statement open?
• Is it possible to build an index on a view
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• More...