What algorithm is used to encrypt the Database M

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

(Continued from previous question...)

What algorithm is used to encrypt the Database Master Key when it is created?

Answer
Triple DES
Explanation
When you create a Database Master Key, it is encrypted using the password you supply with the Triple DES algorithm.

(Continued on next question...)

Other Job Interview Questions

• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• Credentials in SQL Server 2005 are used to access what?
• How many users can be added to an application role in SQL Server 2005?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• When creating a SQL Server 2005 Service Broker message type, what does the EMPTY validation option mean?
• Can you use a CASE statement in a WHERE clause?
• How do you recover the snapshot?
• What does this return?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• More...