Thursday, June 18, 2009

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?

12 comments:

Anonymous said...

I have been interviewed by phone.

y insert statement takes long time in query analyzer?

virtual override and new

where do you deploy email validation component? Local or remote?

abstract class and virtual method

delegates

globalization in asp.net

design patterns

Varun Sharma said...

Thanks for sharing your experience..

Sateesh Kumar said...

thanks

Kebhari ads said...

Thanks. The Keshri Software Solutions is a one-stop site for Asp(.)Net Live Project Training. We have successfully completed several batches and all are placed and working in a reputed company.
Our aim is to provide crystal clear concepts and to boost programming & technology skills of candidates through best Live Project
Training.

Please visit : http://training.ksoftware.co.in/ for more details.

Suba said...

Dot Net is an ever trending technology where it is more preferable by developers to utilize the features in the dot net language. Your article on Dot Net language proves that it is an evergreen technology in the IT market.
Regards:
DOT NET Course Chennai | DOT NET Training Institute in Chennai

vijay antony said...

I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.


Best Java Training Institute Chennai

ragini ragini said...

Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals. digital marketing jobs career opportunities in abroad
Advance Digital Marketing Training in chennai– 100% Job Guarantee

owenmorris said...

I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

pooja saravanan said...

Thanks Admin for sharing such a useful post, I hope it’s useful to many individuals for developing their skill to get good career.

Blueprism training in Chennai

Blueprism training in Bangalore

Blueprism training in Pune

Blueprism training in tambaram

Blueprism training in annanagar

Blueprism training in velachery

Blueprism training in marathahalli

kevin antony said...

Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.


rpa training in Chennai | rpa training in velachery

rpa training in tambaram | rpa training in sholinganallur

sai said...

This is good site and nice point of view.I learnt lots of useful information.
python training institute in chennai
python training in velachery
python training institute in chennai

Sugi Bala said...

Outstanding blog post, I have marked your site so ideally I’ll see much more on this subject in the foreseeable future.
java course in annanagar | java course in chennai


java course in marathahalli | java course in btm layout