# Tutor profile: Lohit B.

## Questions

### Subject: SQL Programming

What are the types of case statements in T-SQL

In SQL Server we have possibility to use two types of Case Statements. 1. Simple Case statement; Here we provide an input expression or column which is compared with the when_expression in the order specified and the respective then clause is returned. 2. Searched Case : evaluates the boolean expressions in the order specified and when it evaluates to TRUE it returns the respective Then clause. If none of them is true then the final Else clause is returned or in its absence NULL is returned.

### Subject: Python Programming

Does python dynamically allow change of the number of parameters passed to a function call.

There is an option to use the asterisk before the argument name (*arg) while defining the function, to suggest that the number of parameters is changed dynamically. A double asterisk can be used to signify a key word arguments (**kwargs). Thus for a function defined as def f(*args,**kwargs) and when we call f(a,b,c,x=1,y=2,z=3) python will assign args=(a,b,c) and kwargs={'x':1,'y':2,'z':3} and these arguments can be used accordingly in the body of t he function.

### Subject: Geometry

What is the perimeter of the biggest circle that fits inside a square, whose length of one side is 2 units.

The biggest circle would be on which has its diameter as 2. hence it's radius will be D/2 or in this case 2/2 = 1 unit. The area of the circle is given by the formula pi*radius*radius= pi*1*1 Hence the area of the circle is pi (22/7 or 3.14 sq units).

## Contact tutor

needs and Lohit will reply soon.