Interview Experience with PWC

Recently I gave an interview with PWC.. Though not selected, I would like to share my experience with you all. Here are the list of questions asked in Round I:


01. Tell me about your education background, work profile.
02. Is dot net object oriented?
Here I said 'YES'..so next question

Lets start with OOPS
------OOPS------------
03. What is an abstract class?
04. What is an interface?
05. What is the difference between abstract class and an interface?
06. When to use what (abstract/interface)?
07. Give practical scenario regarding usage.
08. What is the relation between virtual and override keyword?
09. What is Polymorphism?
10. What is method overloading and method overriding?
11. What is singleton class?
12. When to use singleton class?
13. Any class in dot net framework that is an example of singleton class?
14. What is inheritance?
-------------------------

------SHAREPOINT-------------
You have worked on SharePoint also....YES
SharePoint coding or just Out-Of-Box? ... Coding

15. What is a web part?
16. Advantage of web part?
17. How to deploy a web part..step by step
18. What is the command line utility used in SharePoint?
19. How you can implement List Item listener?
20. Scenario: You need to check before inserting an item to list that whether the EmpID( field) is unique or not? How will you implement?
21. How will you deploy a feature?
-------------------------

-------Database-----------
22. What is an index?
23. How many types of index are there?
24. How many index I can have on a table? Any max limit?
25. What is difference between a primary key and unique key?
26. What are constraints?
27. Name any constraint?
28. Scenario: Table: EMPID, EMPDEPT, SALARY. You need to restrict that one can insert a row where salary is less than 5000. How will you implement that?
29. What is trigger and of how many types?
30. Have you worked on cursors?..I said no..that's why no further questions
---------------------------

--------DOT NET-----------
31. What are attributes in dot net?
32. Can we define user defined attributes?..IF yes then How?
33. How web service communicates between two non-compatible platforms?
34. Can web service preserve state? How?
35. What is singleton web service?
36. When we add a class file, what remains the default assess modifier?
37. Difference between protected internal, protected ?
38. What is MVC?
39. How will you relate MVC with 3-tier architecture?
--------------------------

-------Process Oriented----------
40. Can you name and explain any design pattern with example
41. Have you ever used any defect analysis?
42. What type of proceed flow you use?
43. Have you ever designed design document?
44. What are the main parts of a design document?
45. What tool you used in order to draw class diagrams?
46. Any idea regarding UML?

Interview with Wipro

1. Difference between dot net framework 1.1 and 2.0

2. Difference between datagrid and gridview

3. ADO.NET architecture

4. How garbage collection works

5. Level of GC

6. Which class to use for xml manipulation

7. Diff between XML reader and XML Document class

8. How to jump to particular node without traversing

Interview with IBM

these are the questions asked in IBM interview...

1. Rate yourself in ASP and ASP.NET
2. Rate yourself in VB
3. What is Activex Object?
4. How many types of ActiveX objects are there?
5. What is diff between ActiveX DLL and ActiveX EXE?
6. When to use ActiveX DLL and when to use ActiveX EXE?
7. What is COM+?
8. How you can use COM in .NET?
9. What is assembly?
10. What are different parts of assembly?
11. How many types of assemblies are there?
12. What is singleton assembly?
13. What is Satellite assembly and how to create it?
14. What is the difference bewteen datareader and dataadapter?
15. What is Dataset? Explain..
16. How to establish a conn to a database?
17. How to fetch data using datareader and sqldataadapter?
18. What are various autentication mode in IIS?
19. What is difference between authentication and authorisation?
20. Explain authentication process.. what changes is required in web.config?
21. How to impliment exception handling in ASP.NET?
22. How to handle application error/exception in ASP?
23. What is GAC?
24. Why GAC is required?
25. What is Normalization?
26. Explain different types of Normalization Form with examples.
27. What is trigger?
28. Explain difference between AFTER and INSTEAD OF triggers.
29. What is transaction?
30. Explain ACID property of trancation.
31. Write the code of how to implemnt trancation in ASP.NET.
32. How many types of joins are there?
33. Write a query to show cross join?
34. Explain the concepts of OOPS?
35. Diff between interface and abstract class?
36. Use of sealed keyword?
37. How to hide data member and function member of base class?
38. Explain inheritance.
39. What is ADO?
40. What is cursor type and lock type?
41. How many cursor types are there and what are the uses of each one of them?
42. How will you delcare user defined data types in javascript?