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

• Which table would you query in your report to get logging information about a job step?
• Which types of replication work with Oracle publishers?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• What does this code return? select 6 | 7 Figure it out without running it.
• What is the scope of the control permission in SQL Server 2005?
• What is a zettabyte?
• How many users can be added to an application role in SQL Server 2005?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin
• Which commands are allowed when the "Ad Hoc Distributed Queries" server option is set to 0 in SQL Server 2005?
• More...