A lady interviewed me. I could have cleared it if she had possessed some knowledge. I even had to correct her questions and her answers. She was counting the points based on my answers!

It's hard to make them agree when they come for an interview having learned the questions and answers someone taught them.

I'm adding the best two of those here:

• [First Question/Answer]
• [Second Question/Answer]

Self Join

According to her table design, the columns of the table are ID and Name. She wanted all the data from the Name column to be space-separated.

I said then you can use STUFF, not a self-join. No self-join with an ID and Name column. I decided to quit my career if I was wrong.

To ensure server-side model validations, what attribute should be used on the action?

I said nothing, only HTTP verbs if required.

In the model, we should decorate fields with attributes required from System.ComponentModel.DataAnotations.

The interviewer said something like [DataAnotations] attribute on the action should be used, like filters and attributes.

I was feeling like fainting!

I lost the interview. I don't mind losing one; I have other offers in hand. But why are these people spoiling our time? I could do something else!