.NET Interview Questions for freshers

.Net, Asp.Net, C#, Ado.Net Questions:-

  1. What is action and Function delegate Difference
  2. What is implement interface and inherited interface
  3. Diff btwn interface and abstract, Which one will choose will doing the develoment?
  4. Yield Keyword, Extension methods, Lamda Expression
  5. Func<>, Expression<> delegate advantages in Lamda Expression
  6. LINQ to Dataset query
  7. I want to load multiple images in the gridview, performance is slow. How to improve the performance
  8. Change Assembly version depends on the .Net version how to do it?
  9. Save Cookies in client system with encrypted format? if yes how to do it?
  10. destructor, Dispose and finilize difference?
  11. ArrayList, Hashtable, SortedList, Idictonary diff?
  12. I have a button in Aspx page, button click event is not firing? for firing event what i have to do?
  13. Which property i have to add to the button?
  14. If you add cause validation false how can we handle page level validation?
  15. New, Override, Virtual, Base keywords
  16. How to call base class parameter constructor from derived class? if base class dont have parameter constructor how to call?
  17. Generic advantages.
  18. difference between Ilist, List, IEnumerable and IQuerable
  19. Which caching technique is good and safety one in .net? why?
  20. Pagination in .Net Gridview or DataGrid? how to improve the performance of loading data in the grid?
  21. Difference between N-tier and N-Layer
  22. Difference between Web Application and WebSite?
  23. Difference between deploying Website and WebApplication?
  24. Difference between MVC, MVP and MVVM?
  25. Difference between Architecture design pattern and appliation design pattern?
  26. Types GOF pattern? Please explain any one?
  27. Constructor types?
  28. when to use Private constructor?
  29. Difference between Dispose and Using Keywords?
  30. When to use CommandBehavior.CloseConnection?
  31. How to handle transaction in Ado.Net?
  32. HTTP Moduler and Handler Functionality?
  33. App Domain Advantages?
  34. what are the types to Pass parameter from Parent to child pages? which one best?
  35. How to check DB value is null or empty?
  36. Best way to validate credit card and Debit card no in .net? if third party means how to do security?
  37. What is Restful webservice?
  38. how to make normal webservice to asychronous one?
  39. Synchonization in c# threading?
  40. How to avoid dead lock in transaction? what is the best way to approach the transaction without lock and dirty read?
  41. Use of DISCO and WSDL files in webservices?
  42. How to do sorting in Gridview? write the code snippets?
  43. which event we can use change the data value before binding in the gridview?
  44. Why we can't achieve multiple inheritance in c#?
  45. Difference between Cookiless session and Normal Session?
  46. Maximum querystring value?

SQL:-

  1. temp and table variables 
  2. Advantages and Disadvantages of Dynamic Sql
  3. Advantages and Disadvantages of Views
  4. Advantages and Disadvantages of Triggers and Types of Triggers
  5. Encrypt the SP before publishing to client?
  6. How to get out parameter from SP?
  7. Type of Function, when to create in-Line or Table valued and Scalar valued function?
  8. Diff betwn Function And SP?
  9. Diff betwn Cross Join  and Natural Join?
  10. Diff betwn SubQuery and Co-related SubQuery?
  11. How to do reverse string in SQL?
  12. Having and GroupBy Keywords?
  13. Diff betwn Intersect and Union?
  14. ISNull and COALESCE Keywords?
  15. PARTITION Keyword?
  16. How to Delete duplicate records from table without using temp table?
  17.  Select last 10 records from a table.


table structure
------         --------     ------        ------
Emp.ID         Emp.Name     Gender        Salary
------        --------    ------        ------

write query to get 2nd highest and nth higest salary from Employee Table.
write query to update male as female and female as male Employee Table.
write query to Get Manager name and Emp name from Employee table. Mananger ID related to Emp.ID
------         --------     ------        ------    ----------
Emp.ID         Emp.Name     Gender        Salary    Manager ID
------        --------    ------        ------    ----------
1        A        M        $8000    6
2        B        F        $9000    6
3        C        M        $7000    5
4        D        F        $8500    5
5        E        M        $7500    1
6        F        F        $7800    1