You are building a .NET assembly that will acces

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

(Continued from previous question...)

You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?

Answer
EXTERNAL_ACCESS
Explanation
The most restrictive permission set should always be used for .NET assemblies in keeping with a secure SQL Server environment. Only the EXTERNAL_ACCESS and UNSAFE permission sets will allow registry access and UNSAFE permissions are not required.

(Continued on next question...)

Other Job Interview Questions

• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• What does this code return? select 6 | 7 Figure it out without running it.
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• What does the SQL Writer service do?
• What is the default type of XML data if you do not specify an arguement?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• You are troubleshooting a Service Broker application ...
• When creating a SQL Server 2005 Service Broker message type, what does the EMPTY validation option mean?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• More...