DBA > Job Interview Questions > Microsoft SQL Server FAQs

Which of the following CREATE ASSEMBLY statement

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

(Continued from previous question...)

Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...

Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets the *minimum* required permission set for a SQLCLR Assembly to access Windows environment variables?

Answer: WITH PERMISSION_SET EXTERNAL_ACCESS

Explanation: The correct answer is 3: WITH PERMISSION_SET EXTERNAL_ACCESS
The EXTERNAL_ACCESS permission set is the *minimum* permission set required for SQLCLR Assemblies to access Windows environment variables, files in the filesystem, Windows registry, and network resources.

(Continued on next question...)

Other Job Interview Questions