Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
And more people looking for a job change. I had been to an interview couple of months ago (I don't want to name the company. Hint: They keep telling "people matter, results count") and it was a horrible experience. Around 500 people had come for the interview that day. I went there at 11:00 AM and had to wait till around 3 PM to take my first round, answering some technical questions on-line. I cleared the first round and then had to wait for another 2 hours for the second round (face to face interview). It was around 6 in the evening when a guy calls me for the interview. I expected the interview to be conducted in a closed room, but it was in someone's workstation. The questions he asked me made me wish i had never come here. Here is one question I was asked Interviewer: "I have a user table and the user name is the primary key. How do you stop users from entering duplicate user names ?" me (tired and confused) : "Primary key is usually autogenerated and not entered by user." So he insisted that the primary key is user name and asked me how to handle situations where user enters duplicate Ids. I don't remember what i answered. And at the end of the interview I asked him what would my job role be as it was not mentioned to me earlier and he says its a 3 months contract job. Worst part they did not even bother to tell the result of the interview and even worst i get another email after 2 weeks asking me to attend another Walk-in interview for .NET. They also mentioned the candidates who have attended the interview before can also attend. I thought this was a good company to work for, not anymore.
Sorry for the rant. feels good after letting it out.
The interview call came directly from one of the HRs of that company. The interview was conducted in the company. And the person who interviewed me wore an Id card with the company's logo on it. So I am assuming there was no consultant involved here.
not sure if it's for development or some unknown call center!
Usually if the job description says "Candidate should be willing to work in night shifts", i don't respond to that as there is a high possibility the job involves lot of talking and very less or almost no coding. But this interview call didn't have a job description.
Hi TK, I was reading your post and bit confused whats wrong in the below question.
Interviewer: "I have a user table and the user name is the primary key. How do you stop users from entering duplicate user names ?"
me (tired and confused) : "Primary key is usually autogenerated and not entered by user."
You can set any column or combination of columns to be a primary key. There is no hard coded rule that "Autogenerated" numbers should be a primary key. For the Interviewer's question, the answer suppose to be, "We should validate the existence of the username before INSERT"
You can set any column or combination of columns to be a primary key. There is no hard coded rule that "Autogenerated" numbers should be a primary key.
Yup, I agree with you on that. But I would not make user name (i.e. name of the person) primary key as there can be 2 people with same name. Back from vacation feeling good and energetic . I don't want to spoil my day thinking about this interview again.
But I would not make user name (i.e. name of the person) primary key as there can be 2 people with same name
I see the problem here. You are confusing username with actual name. Do you have tweeter account? or any bank account with online banking option? Take codeproject as an example (CodeProject uses email id as username). All they use is "username" concept. User name cannot same here. You should select an unique username here. What they gave is the business requirement.
I don't want to spoil my day thinking about this interview again.
I don't want to. But what you arguing is not correct.
I understand that username and actual name are 2 different things. But the way the question was put across by the interviewer suggested he wanted to enter the actual name instead of user name. As i said before it was a long day and i was very tired. Honestly I don't care about that interview, But i appreciate your effort to clear things out. Good day
And at the end of the interview I asked him what would my job role be as it was not mentioned to me earlier and he says its a 3 months contract job.
Sorry I couldn't resist. Last year I have faced the similar situation twice(both are 6 month contract job) & I was pissed off. They just informed that after final interview. They didn't mention anything about the job type in the mail which they sent earlier. After those experiences, always I confirmed(with HR's & consultants) the job is not contract type/other crappy things.