Speridian Technologies .NET Developer interview questions

It was a walk in drive conducted at their campus in technopark Trivandrum. They had not informed the security at the front gate, so they didn't allow to enter the campus. I then called the hr and then they informed the security and they let us in. Many candidates also face the same issue. They didn't even ask us to register even in their sites so we didn't have any emails also. The interview was around 30 minutes. Mainly asked about design patterns, sql sp and func. Difference, joins with eg. , How to improve sp performance, how to install an application in iis, state management, login authentication . The interviewer was mocking all the while. He asked me to wait till the HR comes, I waited around 30 minutes. Then HR came and said they will imform later. But I know they rejected me. Because once or twice I questioned the interviewer on some questions.