TCS placement paper

TCS Tech Interview, GD Topics & Tips, HR Interview Questions asked in a College Placement Paper
TCS TECH INTERVIEW

My tech interview was 80% project based. Some of the single questions I remember are as follows

Any application softwares u know?
diff btwn dbms & rdbms??? What r codd rules?
how many types of relationship? Eg. Of many-to-many relationship?
relationship btwn a foreign and primary key? Smart-key??
eg of left-outer join? Recursive join??
one complex query involving join!
why have u used access instead of oracle in your project?
I: (remember don't mumble in the interview. If ur saying something 'false' show the confidence in u that your answer is correct.) Our client told me so. (then smile to yourself!!)
types of dbms?? Give eg of each!
give an eg of a table which is in 3nf not in bcnf? Eg of reverse??
goal in 5 yours? Can u achieve that??
what is software configuration management?? What is QA??
what is CMM? Why level 5? Advantages of spiral model??

***70% of the interviews are dbms related even if u haven't mentioned dbms as a favorite. Show confidence in all answers. Jus prepare your basics in dbms, ds, os, software engg, oops, c, c++, corejava , sql server, networking (optional) and get your ATTITUDE RIGHT***

HR INTERVIEWS

My hr interview was mixture of discussion, friendly chat, hr, management interview and technical.

meaning of your name? What's special about your birthday? Expand your name to show your personality?
have u prepared for this interview? Sources?
what the common questions asked in hr interviews?
one of us is from tech one from hr. guess who's from hr and who's from tech?
are we Bengali or any other religion?
tell us any website from where u can get all tcs previous questions?
your sun-sign? (mine is Aquarius) common characteristics of Aquarius?
Justify that u r an Aquarius?
do u have a girlfriend?
I: yes. I don't differentiate between boyfriend and girlfriend . Thats why I have a lot of them!!
will u marry your girlfriend?
I: I am only 23. I want to give my spouse all comforts of life that's why I will marry after achieving all pleasures and comforts of life!
do u want your spouse to be from IT industry or a non-it?
do u want your spouse to cook food 4 u or to b a careeristic?
I: I want her to b self-dependant to live her life of her own!
if she hags out with her boss?? Come late at night?
I: I have faith in her. As long there is love-bond btwn us there is no problem and she will not do anything to hurt my feelings. (She was impressed!)
if she works in an equally competitive environment in a company better than yours??
I: (at this point I was frustrated. I want to stop the gal frnd episode) Carrer is my first gal friend. Others come after that.
derive complexity for bubblesort
whats the worst case complexity of qiucksort. Practically describe insertion sort.
depth of a binary tree. Derive expression?? Height of binary tree??
eg of recursive function? Show by an eg.
disadvantage of circular linked list? Insert in a doubly linked list.
hobbies? in priority wise?
I: software collection, listening to English hard rock, reading autobiography
whose autobiography?
I: business @ speed of thought by bill gates..
what kind of books u read?? Fiction or non-fiction?
what the latest version of windows?
I: windows Longhorn!!
what type of hard-rock? do ever people around u complain to loud noise? Why u listen to hard-rock? Name some famous rock stars.
career plan?? How can u contribute to tcs?
mention some point abt yourself not written in your bio-data? Beware if u say something common your candidature will simply be cancelled?ready to sign agreement bond now?what other companies u appeared for?? Why were u rejected ??
do u have any question?
I: career path in tcs?? How can u become a project manager with tcs provided u perform well? How tcs is going to be among global top 10 by 2010?
How was my performance? How can I improve myself?

I believe that is the greatest tcs resource one can find in internet. So get benefited from it! Just remember to get your attitude right. Guys remember besides apti and interviews dress code, smartness, eye contact, positive attitude, friendliness, blue form, communication skill, extra curricular activity, general knowledge, presentation, iq, mental ability, decision taking ability are also tested during interviews. This is from a personal experience besides ask the interviewer as many questions as u can. Show the interviewer you are dying 2 get in his organisation.