Question 37


Answer B is correct. EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry. The default setting is SAFE, which is the most restrictive permission set. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, environment variables, or the registry.

For more information, see the following sources:

  • Chapter 3, "Implementing Database Objects"

  • SQL Server 2005 Books Online: "Samples and Sample Databases, Samples, SQL Server SQL Server Database Engine Samples, Programmability Samples, CLR Programmability Samples"

  • "Programmability," http://msdn.microsoft.com/sql/learning/prog/default.aspx

  • "Assemblies (Database Engine)," http://msdn2.microsoft.com/en-us/library/ms186221(SQL.90).aspx




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net