In SQL Server 2005, if you want the keys securin

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

(Continued from previous question...)

In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?

Answer
Certificates

Explanation
Certificates have an expiration data associated with them. This allows you to issue them to users and force a reissue in order to maintain their access to data.

(Continued on next question...)

Other Job Interview Questions

• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• What does @@MAX_PRECISION return?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• How large a database can you have in this edition of SQL Server 2005? ...
• Can you use Full-text search to index this column?
• Where does Profiler store its temporary data in SQL Server 2005?
• What does the sqlwb utility do?
• True or false, Report Builder supports using the LIKE function inside filters?
• More...