Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Lohit B.
Senior Analyst in Accenture
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

What are the types of case statements in T-SQL

Lohit B.
Answer:

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.

Python Programming
TutorMe
Question:

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

Lohit B.
Answer:

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.

Geometry
TutorMe
Question:

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

Lohit B.
Answer:

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).

Send a message explaining your
needs and Lohit will reply soon.
Contact Lohit
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.