Domande di colloquio presso MSPL

1.difference between dropdownlist,checkbox and radio button. 2.CTE in sql server 3.Temperory Table in sql 4.difference between procedure and function 5.difference between session state and view state. 6.how to pass data from drop downlist to radio button 7.There is a table in database where birthday and name coloumn is there.write query for the person who has today birthday? 8.There are 3 coloumns name, fees1 and fees2.write the query for acessing name and total fees? 9.Types of function in sql server? 10. what is user defined function? and some more queries......