Monday, March 18, 2013

By failing to prepare you are preparing to fail

"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)