Mind Tree .Net Interview Questions

1. I have the string in format of Rs.2, 50,000. Now I want to read the string value as 250000 and insert into database (let assume that Rs 2,50,000 coming from third party like web services, wcf services, or from other application ) can u write the code to remove the commas.
2. Can a stored procedure call another stored procedure?
3. Difference between function and stored procedure?
4. How can you know the number of rows affected by last SQL statement?
5. What is the use of COMMIT TRANS?
6. What are cursors?
7. Types of indexes?
8. What is the purpose of UPDATE STATISTICS?
9. Can u write the code for , I have the date time columns in data base which it stores in the format of date time 01/09/2010 10:02:56 now I want to display the date as 1- sept-2010 ?
10. How do you find the duplicate rows in the table?
11. What is a typed dataset?
12. What are collection classes?
    Array list, dictnory…, Can u tell me the use of dictionary data type?
13. What are generics?
14. What is the use of Partial Classes
15. What is the use of Enum data type? 
    Side question: it is reference type r value type?
16. For ex I have
    
    
    
    
    Public enum
    {
    
    
    
    
    Sunday =1;
    
    
    
    
    Monday=2;
    
    
    
    
    Tuesday=3;
    
    
    
    
    Wednesday=4;
    } 
    I need to fill this into dropdown list?
17. How the security is implemented in your project? 
    
    
    I told like, by implementing the 3-tier architecture, using forms authentication, encrypting the password, query strings.
    Interviewer how you encrypt the password, I mean which approach u choose, or client specified particular process. .. Can u tell me how many methods  you know to encrypt
18. I have string value like “This is Reddys” now I want to spilt the word at white spaces and collect the words into array list?
19.  I have a webpage with some text boxes and one button with name refresh, when I click the button all the textboxes should get refresh, how can u achieve this?
    In button event we can write the textbox1.text=”” or text.clear(); 
    
    
    
    
    Side question if I have 25 control in my webform then for 25 controls you will write text. Text=”” ------ so on. 
    
    
    
    
    How much u can rate Ur self in asp.net out of 5---
20. Does a form authentication is work when cookies are turn off at browser side? H’w can u achieves the forms authentication?
21. Difference between forms authentication and windows authentication? 
    Side why windows authentication is more secured when compare to forms authentication
22.  Can u write the query for to retrieve all records which are modified in last 10 days?