A certificate is which type of security mechanis

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

(Continued from previous question...)

A certificate is which type of security mechanism?

Asymmetric Key
Explanation
A certificate is an asymmetric key that provides encryption in addition to authentication of an entity.

(Continued on next question...)

Other Job Interview Questions

• What will occur with the following code in SQL Server 2005 if executed by Alice?
• What does @@MAX_PRECISION return?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• What does the SQL Writer service do?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• More...