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?

19 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

nivatha said...

Great content thanks for sharing this informative blog which provided me technical information keep posting.
Data Science training in rajaji nagar | Data Science with Python training in chenni
Data Science training in electronic city | Data Science training in USA
Data science training in pune | Data science training in kalyan nagar

Anonymous said...

This looks absolutely perfect. All these tiny details are made with lot of background knowledge. I like it a lot. 
angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

gowthunan said...

I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.
safety course in chennai

Ishu Sathya said...

After reading your blog, I was quite interested to learn more about this topic. Thanks
Selenium Training in Chennai
Selenium Training
iOS Training in Chennai
Digital Marketing Training in Chennai
core java training in chennai
web designing course in chennai
web designing training in chennai
web design training in chennai

Safety Professionals said...

She noticed a wide variety of pieces, with the inclusion of what it is like to have an awesome helping style to have the rest without hassle grasp some grueling matters.
iosh course in chennai

zasi said...

Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you an email. I’ve got some recommendations for your blog you might be interested in hearing.


AWS Training in Pune | Best Amazon Web Services Training in Pune


Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai


AWS Training in Chennai |Best Amazon Web Services Training in Chennai


AWS Online Training | Online AWS Certification Course - Gangboard

Xplore IT Corp said...

Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
dot net course training in coimbatore
Embedded systems training in coimbatore