Month: April 2010

C# – Common interview questions

  1. What is value type and reference type?
  2.  What is the use of dispose method?
  3. Give an example of method overloading and method overriding?
  4. What is class? Give a real life example.
  5. What is Object? Give a real life example.
  6. What is abstract class?
  7. Why partial class?
  8. What is predefined data type and user defined data type? Discuss with example.
  9. What is verbatim string? How it works?
  10. What is the difference between string and string builder?
  11. Why and how constant is used in C#?
  12. What is enumeration type? How it works?
  13. What do you know implicit and explicit conversion? Give an example.
  14. How switch statement works? What is the function of default in switch case?
  15. How break and continue keyword works? Give an example.
  16. What is the difference in for loop, while loop and do while loop?
  17. What is boxing and unboxing?
  18. What do you know about namespace and nested namespace? Why namespace is used?
  19. How parameter is passed by reference? Give an example.
  20. What is constructor? What is constructor overloading?
  21. Why constructor is used?
  22. Why read only variable is used?
  23. What is the difference between read only and constant variable?
  24. What is static class? Why static class is used?
  25. What is inheritance? Why is it necessary?
  26. What is sealed class? Why sealed class is used?
  27. What is abstract class?
  28. What is the difference between abstract class and interface?
  29. Is there any difference between “ ++I”  and “i++”? How it works?

SQL Server: Common Interview Questions

  1. What is the difference between Delete and Truncate in SQL Server?
  2. What is trigger? Write syntax of trigger.
  3. What is the difference between “char” and “varchar”?
  4. What is function in Sql server? How many types of functions?
  5. What is stored procedure? Write syntax of stored procedure?
  6. How parameter is passed to sql function and how call a function?
  7. What is input and output parameter in stored procedure? How it works?
  8. Write syntax to create a table.
  9. What is view? What is the difference between table and view?
  10. What is constraint? Tell different type of constraint and its functionality.
  11. Discuss different type of joining. How it works?
  12. How left outer joining works?
  13. How inner join works? Give an example.
  14. How outer join works? Give an example.
  15. How right outer join works? Give an example.
  16. How full outer join works? Give an example?
  17. How Cross Join works? Give an example?
  18. Which one faster – Inner join or Cross Join?
  19. How do you move all data to another table using query?
  20. Find out the maximum salary from a salary table?
  21. How do you find number of employee from employee table?
  22. What is commit and rollback? How it works?
  23. What do you know about transaction block? How it works?
  24. How primary key constraints, foreign key constraints and default constraints works?
  25. How not null constraints, check constraints, rules constraint and unique constraints works?
  26. What are DDL and DML? Give example.
  27. How distinct keyword works?
  28. What do you know about sql wildcard? Give example.
  29. How to select top 10 employees from employee table?
  30. How “between” and “in” operator works?
  31. Union / Union all, requirement and difference.
  32. What is sub query? Give an example.
  33. How “having” clause works?
  34. How “group by” clause works?
  35. Why “Where” clause is needed?

ASP.net : Common Interview Questions

  1. What is MS .NET?
  2. What is IL/MSIL? What is CLR?
  3. How ASP.net works in web?
  4. What is the difference between layer and tire?
  5. How ASP.net Provider model works?
  6. What is directive in asp.net pages?
  7. What is master page and contant page?
  8. What is ASP.net themes? How it works?
  9. What is web.config and machine.config?
  10. What is the difference between “Web.config” and “Machine.Config”?
  11. What is state management in ASP.net? What is server side and client side state management?
  12. How view state, hidden field and cookies works?
  13. How query Strings , control State are managed?
  14. How application state, session state are managed?
  15. What is caching how it works?
  16. What is the use of @ Output Cache directive in ASP.NET.
  17. What’ is the sequence in which ASP.NET events are processed?
  18. In which event are the controls fully loaded?
  19. How does ASP.NET maintain state in between subsequent request?
  20. What is event bubbling?
  21. How do we assign page specific attributes?
  22. How do we ensure view state is not tampered?
  23. What is the use of @ Register directives?
  24. What is the use of Smart Navigation property?
  25. What is AppSetting Section in “Web.Config” file?
  26. Where is the ViewState information stored?
  27.  How can we create custom controls in ASP.NET?
  28. How many types of validation controls are provided by ASP.NET?
  29. Can you explain “AutoPostBack”?
  30. How can you enable automatic paging in DataGrid?
  31. What is the use of “GLOBAL.ASAX” file?
  32. What is a SESSION and APPLICATION object?