SQL Server 2005 and CLR

Take This Test

1)	The maximum length of a Stored Procedure name is ____________ characters

2)	Stored procedures may contain up to __________ input and output parameters

3)	What will happen if you execute the following code
	Create procedure dbo.ap_Eq!dByMakeModel_List @chvMake varchar(50), @chvModel varchar(50) as select Eqld from dbo.Equipment where Make = @chvMake and Model = @chvModel
4)	Choose all object types which are supported by CLR Integration in SQL Server 2005

5)	Which of the following assembly/namespace can not be used with CLR database objects

6)	you have created a class to store your CLR sqlprocedures, all method that will become database objects should be:

7)	Any .net assembly can be directly used with a SQL Server 2005 database?

8)	Match the permission sets with their correct definition.

9)	Choose the correct syntax to create a trigger is:

10)	Which query would fetch a list of all registered assemblies in a sql server 2005 database

11)	Which query would fetch a list of all programmable database objects and assembly modules (CLR database objects)