Which key does the OPEN MASTER KEY statement ope

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

(Continued from previous question...)

Which key does the OPEN MASTER KEY statement open?

Answer: This opens the Database Master Key

Explanation: This statement is used to open the Database Master Key for the database in which it is run. A password must be supplied as well.

(Continued on next question...)

Other Job Interview Questions

• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What is the timestamp datatype used for?
• How can you quickly determine if any of these indexes are really being used?
• More...