Which is larger in size in SQL Server 2005 if yo

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

(Continued from previous question...)

Which is larger in size in SQL Server 2005 if you are using symmetric keys?

Answer
Ciphertext

Explanation
Ciphertext is larger and can be calculated using the following formula:
Size = ( FLOOR (8 + D)/BLOCK) + 1) * (BLOCK + BLOCK + 16)
where D is the data size in bytes, BLOCK is the block size (8 or 16, depending on algorithm) and Size is the new size in bytes of the ciphertext.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between a return parameter and an OUTPUT parameter?
• Where is varchar(max) data stored?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• What is a zettabyte?
• When starting SQL Server 2005 from the command line, what does the -h switch do?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?
• What algorithm is used to encrypt the Database Master Key when it is created?
• What does the SQL Writer service do?
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• More...