Sponsored Ad

Saturday, March 13, 2010

C# – SQL – Interview Questions – Mercer Gurgaon 2010

I gone through personal .NET interview in Mercer Gurgaon. I remember some of the interview questions.  I am posting here for your help.

 

C# Interview Questions:

1. What is OOPs?

2. What is Object?

3. What is Abstract Class?

4. What is abstract function?

5. What is Arraylist, what type of data it store?

6. Boxing and Unboxing?

7. Override and New keywords?

8. Sealed Class?

9. How can you stop a class being inherited?

10. How can you stop class being instantiated?

11. What is interface?

12. Multilevel and Multiple inheritance?

13. How can you handle abstract function without implementing it in derive class?

14. List the datagrid events?

15. How many number of times item data bound event will be called for 10 rows in grid? What property will you use to check header in datagrid?

16. What is HTTP handler? How will you implement?

17. Write a code to add a user control to a page?

18. Difference between user control and custom user control?

19. How many master page a project can have?

20. Write a code to add msterpage in a page?

21. Difference between string and string builder?

22. types of Design patterns? Implement one of them?

23. What is UML ? Design a UML diagram?

24. What is MVC?

25. Can we have multiple update panel in AJAX, Write a code to call another update panel on click on another?

26. what are collections?

27. delegate and events?

 

SQL Interview Questions:

1. Difference between procedure and function?

2. What is temprary table, how to use it?

3. what is trigger and how to use it?

4. How many level a trigger can be implemented?

5. How to implement transaction in database?

6. Difference between primary key and unique key?

7. Cluster and Non Cluster index? create it. How many non cluster index can be there?

8. Can we define cluster index on simple column?

9. create a package?

10. What is implicit and explicit cursor?

11. What is difference between refcursor and cursor?

and so many……….

4 comments:

  1. very very helpfull
    ReplyDelete
  2. amit gahlot

    this questions are very-2 benifical for me for facing a interview
    ReplyDelete
  3. Very Helpful post thanks a lot.
    ReplyDelete

Sponsored Ad

More Related Articles

Website Update

Followers