"By failing to prepare you are preparing to fail." is one of the realistic quotes from one of the founder fathers of United States Of America Mr.Benjamin Franklin. This quote really applies to the job seekers who are extremely talented and skillful but are unprepared for the situation. Here lies the difference between the talented and the average individuals. The talented individuals often lack preparation thereby making the life easy for the average individuals who are prepared for the situation.
So be prepared today for a greater tomorrow.
Company :- COGNIZANT Technology Solutions
Below are some of the Interview Questions for 2-3 year experienced people:-
1st Round (Technical by Sr.Developer)
1) What is the difference between Abstraction and
Encapsulation? How to achieve it?
2) What is the difference between Abstract class
and Interface?
3) What is the difference between Constant and Static
Variable?
4) What is a Static class? What is the advantage?
5) What is a Delegate? Write a code for Delegate?
6) What are Anonymous methods?
7)What are Events and Event handlers? How to
register an event?
8)What is a web service? Write Steps to consume a web
service.
9) What is the difference between Respone.Redirect()
and Server.Transfer() method and when would you use each of them?
10)
What does Postback mean?
11)
Explain the ASP.NET page life cycle?
12)
What are Cookies? Where are they stored?
13)
What are Master Pages? How to refer/use the
controls on the Master Page on the Content Page?
14)
What is the difference between Function and
Stored Procedure? Write Syntax.
15)
What is a Trigger? Different types of Triggers?
Write Syntax.
16)
What is a Schema?
17)
What is a Synonym?
18)
How to handle the Exceptions in Stored
Procedure?
2nd Round (Technical by Team-lead)
1) Tell your experience in your organization. What
did you learn from there?
2) If given a chance what would you like to improve
in your current application?
3) The ASP.NET page loads very slowly. How would
you optimize to increase the performance?
4) When would you use clustered and non-clustered
index?
5) How would you pass the exceptions occurred at
various layers (DAL layer, BL Layer) to the UI Layer?
6) How would you log the exceptions at various
layers?
7)If there are 2 tables Table-A (With Clustered
Index) and Table-B (Non-Clustered Index) having more than 1Lakh records. Which
operation (Select or Insert) would be efficient?
8)If there are 2 tables Table-A (With
Non-Clustered Index) and Table-B (No Index) having 100 records. Which table
would fetch data faster?
9)You have been assigned a task with a time frame.
You are aware that you will not be able to complete the task on time. How will
you handle this situation?
10)How would you optimize a Stored Procedure for
performace tuning?
3rd Round (Technical by Project-manager)
1) Tell me the Architecture of your project.
2) How is data transferred from one layer to
another layer (UIàBLàDALàDB)?
3) Describe various optimization techniques to
improve performance.
4) Does Session use Cookies? If Cookies are
disabled on client machine, will Session work?
5) Write a Query to return non-matching rows from 2
tables.
6) Write a Query to return the Manager name of an
employee where the manager is also an employee.
4th Round (HR by HR Head)