A certificate is like which type of key in SQL S

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

(Continued from previous question...)

A certificate is like which type of key in SQL Server 2005 encryption?

Answer
An Asymmetric Key

Explanation
A certificate is like an asymmetric key and can validate the identity of the issuer.

(Continued on next question...)

Other Job Interview Questions

• What does the Log Reader agent in SQL Server 2005 replication do?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• What can be used to ensure that a field in a table only accepts a certain range of values?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• To recover an instance of Notification Services in 2005 on another server, what information would you need?
• More...