CLR Flashcards Preview

70-464 Certification > CLR > Flashcards

Flashcards in CLR Deck (7)
Loading flashcards...
1

What are the permissions you can set in WITH PERMISSION_SET when creating an assembly?

SAFE
EXTERNAL_ACCESS
UNSAFE

2

What is SAFE permission_set?

It is the most restrictive permission set. It cannot access the network, files, env variables or registry

3

What is EXTERNAL_ACCESS permission_set?

Enables assemblies to access certain external system resources such as files, networks, env variables and registry

4

What is UNSAFE permission_set?

Unrestricted access both within SQL instance and without. Very UNSAFE (Hence the name)

5

What is the code to implement a .net framework assembly?

EXTERNAL NAME Assembly.Class.Method

6

What is the syntax to use a DLL in SSMS (IE: CLR stored procedure)?

CREATE ASSEMBLY AssemblyName FROM N'C:\PATH\ASSEMBLY.DLL' WITH PERMISSION_SET = [SAFE,UNSAFE,EXTERNAL_ACCESS]

7

How do you enable the system to use CLR Integration?

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;