Interview Questions

They are DEFINE CLUSTER, DATA and INDEX.

Validation controls are responsible to validate the data of an input control. Whenever you provide any input to an application, it performs the validation and displays an error message to user, in case the validation fails.

ASP.NET 4.0 contains the following six types of validation controls:

   => CompareValidator - Performs a comparison between the values contained in two controls.
   => CustomValidator - Writes your own method to perform extra validation.
   => RangeValidator- Checks value according to the range of value.
   => RegularExpressionValidator - Ensures that input is according to the specified pattern or not.
   =>  RequiredFieldValidator - Checks either a control is empty or not.
   => ValidationSummary - Displays a summary of all validation error in a central location.

What are your weaknesses?

This is a very common interview question for many jobs across industries. Most people feel Answering strengths is easy but weaknesses is difficult. If approached the right way this question will give you chance to build trust. You have 3 options/approaches to answer this question. 

1. Deny having any weaknesses. This approach is least common and surely not the way to go.

2. Spin a Weakness into a strength. Like, "I'm a perfectionist" or "I care too much"

Note - This is very common approach and some interviewers think you are not being honest. 

3. Give an honest answer (Recommended). Answer the question honestly without shooting yourself in the foot. 

E.g. My weakness is public speaking, I am working on it. Ofcourse make sure this is not the primary requirement of the job. 

Check EIBRESP after the call or use the HANDLE condition.

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.

.NET Framework is a complete environment that allows developers to develop, run, and deploy the following applications:

 => Console applications
 => Windows Forms applications
 => Windows Presentation Foundation (WPF) applications
 => Web applications (ASP.NET applications)
 => Web services
 => Windows services
 => Service-oriented applications using Windows Communication Foundation (WCF)
 => Workflow-enabled applications using Windows Workflow Foundation (WF)

I like new challenges and fortunate to develop. As long as I keep doing these, I don’t think I’ll need to alter. I’d like to consider that this relationship lasts for many years. However, I haven’t set a period of time limit as such.