A .NET assembly running with UNSAFE permissions

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

(Continued from previous question...)

A .NET assembly running with UNSAFE permissions can do which of the following?

Answer
All of the above

Explanation
CLR code running with UNSAFE permissions can access virtually any resource inside or outside of SQL Server without restriction. This is one reason only a sysadmin can create an assembly as UNSAFE.

(Continued on next question...)

Other Job Interview Questions

• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• What does SEND do in SQL Server 2005?
• What is an example of hardware partitioning?
• True or false, Report Builder supports using the LIKE function inside filters?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• What feature of SQL Server 2005 would help you get the snapshot transferred?
• What algorithm is used to encrypt the Database Master Key when it is created?
• More...