Dotnet Interview Questions of MindTree company

[Koppolu]

hello all , I have completed one year in net programming field and was working for a multi national company. But as I have interest in joining the mindtree software company can you guide me in this case as I am not finding questions and answers for the interview . I will be shortly giving the interview and need to crack it. So needed your help. Please provide with some .

[Masters]

I wish to say you all guys that the Interview Procedure in the mindtree is as follows:
1. the initial procedure is the conduction of the Written Test
2. 1st Round- Face to Face Technical Interview
3. and the Final Round will be conducted Face to Face by an Technical Interview
4. and the final round is cleared through HR Round

[Educated]

I would suggest you with some questions to just brush up and they are as follows.
Difference between the function and stored procedure.
What are the cursors.amd also the types of indexes.
Purpose of the Update Statistics.
What is the typed dataset.
What are the collections classes and define them.what are the generics.
What is the use of enum and what is the purpose.

[Koppolu]

Thanks for the reply as I found the answer very useful. But can you provide some of the answers which you questioned as I am not able to get the answer related to your questions. But anyways thanks for the first reply as I gave me a clear idea regarding the same.