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.
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.
Oh! The ICSE exams are so breathtaking!!! Its sooo difficult to squeeze out time for some programming. The board exams were started to only plague our lives. Can't get enough of some subjects while the others are too easy. Only 3 weeks to go. Countdown has begun. The more near the boards come less I feel to study!!
Things seem to get messed up. The funniest thing is that mistakenly I wrote some C# syntax in my computer paper for a JAVA program during the pre-boards. My teacher was good at scratching off my answer there.!
Emotions- something that both strengthens and weakens you.
Yes this would be my class 10 exams. Thanks for your wishes. How I wish that our computer paper comprised of something more than the basics in BlueJ!!!
I have also worked in GWBASIC initially while all my friends have worked on QBASIC. In fact, quite funnily none of my school friends can work on DOS! Its all Greek and Latin to them. I don't get why most of the students find the computer papers so difficult with such fundamental things in place.
In our junior classes even QBASIC is now changed in many schools with C++. Quite interesting as to how the syllabus is changing!!
It is so difficult to get a new one. I have been going to their offices since about a month now. Every time they say that there are changes going on because of the new quota rule and gives a new date to check out again.
Today the HP guy finally asked to come tomorrow. I hope there won't be any delay anymore.
I also heard that agents are earning good during this period. They will get you a connection during this period by charging some extra money.
I also wanted to ask is there a considerable difference between the services of different gas agencies that anyone has ever experienced. I remember someone saying Indane doesn't have a good availability here. The wait time is more.
Leave alone a new connection we are already too bothered getting a cylinder. Booking problems are up there always. And yes, the delivery guys are even charging extra over the bill!!! Induction cookers are such a relief...!
Leave alone a new connection we are already too bothered getting a cylinder. Booking problems are up there always.
That concerns me as they have just allotted a single cylinder at the moment. You can apply for the another one only after 6 months. But they say the cylinder comes within 4-5 days of your booking.
The rules weren't the same when my friend took a new connection a year back.
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.