Multiple choice technology databases

Which classes from the .NET Framework can be used in SQLCLR assemblies with permission set SAFE?

  1. All of them. Permission set SAFE just restricts the use of unmanaged code

  2. None. To use classes from the .NET Framework in SQL Server you need at least permission set EXTERNAL

  3. Some of them are tested specifically for the use within SQL Server, they can be used

  4. Permission sets have nothing to do with SQLCLR
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQLCLR's SAFE permission set allows only specific .NET Framework classes that have been tested and verified for SQL Server use. Not all framework classes are available - SAFE restricts to a subset of supported assemblies designed for SQL Server hosting. Option A is wrong because SAFE restricts more than just unmanaged code. Option B is wrong because some classes work with SAFE. Option D is wrong because permission sets directly control SQLCLR capabilities.

Keep practicing — related questions