.Net Face to Face interview questions for 5+ Years of experience along with the skills C#.Net, ASP.Net, SQL Server, WCF & MVC

1. How to bring data from database to application in XML format
2. How to increase the performance of ASP.Net application?
3. How to increase the performance of Stored Procedure?
4. What is the difference between function & stored procedure?
5. What is the session management technique?
6. What is the difference between Web controls &HTML controls?
7. I don’t want to use session management for my 3 pages application, How can I do state management?
8. What is Cache?
9. What are indexes? What is the difference between them?
10. What is temp table and table variables?
11. What are clustered and non-clustered indexes?
12. What are cursors?
13. How Garbage- Collector know that ha to clear the objects of not in use?
14. <input type= “Text” Id= “txt”>, How can I call this control from code behind?
15. What are transactions in C#, SQL and WCF?
16. What are handlers?
17. What is the security in Asp.Net?
18. What is abstract class?
19. Why we have to use Razor Engine?
20. What are indexes, when we have to use and when we shouldn’t use?
21. If we use indexes, what happens?