Which key provides the strongest encryption?

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

(Continued from previous question...)

Which key provides the strongest encryption?

Answer
AES (256 bit)

Explanation
The longer the key, the better the encryption, so choose longer keys for more encryption. However there is a larger performance penalty for longer keys. DES is a relatively old and weaker algorithm than AES.

(Continued on next question...)

Other Job Interview Questions

• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• To recover an instance of Notification Services in 2005 on another server, what information would you need?
• In SQL Server 2005, what does the CREATE SERVICE command do?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• What is the default type of XML data if you do not specify an arguement?
• Can you call Notification Services APIs from unmanaged code?
• More...