TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions



I had my technical interview on last Saturday, 18th November 2006. The 
interview was so cool.  The  interview was around 35 minutes.  They  
concentrated on DBMS, C programming language, OOPS concepts with C++ and 
Operating system.

Before interview he read my resume.

Interviewer: Tell me about yourself.
Me: told about myself without any problem as I have  prepared already for 
this question.

Int: Explain about  joins.
Me: Explained  various types of joins with examples.


Int: What is DBMS?
Me: explained the def of dbms and expalined the various dbms products in 
the market.

Int: what is 'Index' in DBMS?  
Me: I did n't  answer this question.

Int: what is a key and its types?
Me: explained  primary key, foreign key, super key with examples.
There is a long discussion on the concept of foreign key. He asked me to 
explain it with examples. I've taken two tables 'Emp' and 'Dept' tables 
and explained neatly.

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions





Some dbms questions are

What is Embedded SQL?
stored procedures?
integrity constraint?
cursors ?
views?

some simple SQL queries were asked. 

Then he asked about my MCA academic project work. I explained  about the 
project.

Int: What are the softwares that you've used for the project development?
 
Me: Told about the software. (j2ee)

Then they  started asking me few basic concepts on Java like abstract 
class, interface etc.

Int: How many marks will you rate yourself in C on a scale of 5?
Me: Rated myself as  4.

Some questions on "c"

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions




What are the differences between C and C++?
What is a Pointer?
Overloading and overriding concepts from C++.


Int: Write a program to swap two numbers using only two variables. i.e 
without making use of third variable.
Me: Sure. i did it.

some more questions from Operating systems like 

Memory management?
paging?
demand paging etc?




Then to write a C program to print the following structure and started 
writing it on the paper.
                         *
                        *  * 
                      *  *  *
I told them that 'I need some time to think about the logic involved, for 
generating the given structure. But I can print the same in Right angled 
triangle shape' and I started writing the structure on the paper like..
                *
                * *
                * * *
They asked me to do that.They preferred only the logic. They asked me to 
explain it. I explained.


TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions



Int: Do you have any questions to ask us?
Me: can I get the chance here in TCS to work on J2EE technologies, if I 
get selected, as I'm sound in that area?

Int: saying 'Sure, you'll get the chance, and I'm also working on that 
platform these days. But it may not be immediately after the completion of 
your training'. 


After that TCS people have announced the results along with the interview 
schedule. My interview was on 21st Tuesday. given a form to us to be 
filled before coming to the HR interview.

I've not used the words 'sir' or 'madam' to salute them. I even called 
both the interviewers with their names in my technical round. they expect 
to be called like that.

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions




Managerial Round of Interview: (On 21st November 2006)
    This interview was  also so cool for me. With the confidence I've 
gained from Tech round, I've attended this interview with coupled 
confidence.
Actually my interview was scheduled at 11:00 in the morning. But it became 
too late again. It started at around 4:00 in the evening. To my surprise, 
I was asked all HR questions in this round even though it is said to be 
Managerial Round. This interview also consisted of only one member. But 
many of the candidates who were appeared for the MR interview were been 
asked questions based on their academic project and/or technical questions 
only, in this round of interview. I was asked the following questions 
like....
Tell me about yourself, what are your areas of interest, positive and 
negative points in you, your achievements, About TCS, Why should we hire 
you etc (Some more questions, but all these are purely HR questions. Its 
duration was 20 minutes for me.)
    After it is over, they announced the results. I was through the MR 
also. Again they announced the HR interview schedule. For me it was 05:15 
in the evening on the same day. In this round also TCSers eliminated some 
candidates.


TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions


HR interview: 

I've had a stress kind of interview here. The interviewer seems to start 
argument with what ever I say. And I was asked even unexpected questions. 
This round consisted of Project related questions even though it is HR 
interview. 

   
Hr: Tell me about yourself?
Me: keep telling about my PG briefly and moved on saying my achievements, 
goals etc. 

Hr: why didn't you select campus of any university in the state?
Me: given the reasons. 

Hr:  he asked me the subjects of the previous sem than 3-2 i.e 3-1
Me: told some of the subjects. 


Hr: Can you tell me the subjects that you are having in your last semester 
(3-2) of MCA.
Me: told the subjects.

Hr: Do you have DBMS in your curriculum?
Me: yes, in our second year of MCA.

Hr: what are the concepts that you know from DBMS?
Me: written all the major concepts related to it on the paper.
Int: its ok.

Hr: Explain your project in detail.
Me: Explained the project clearly. 

Hr: Asked questions on on project design, especially on database design 
process  .
How many tables are there in your application? 
Me:   It consists of 18 tables totally.

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions


Int: why that many number of tables? Why don't you maintain all the data 
in a single table? 

Me: told the problems with that approach.
Int: if so, why don't you create a separate table for each column?
Me: even then told the problems with this kind of approach also.
Int: again the same question, why that many tables?

Me: I've told about normalization and its types.
Int: can you explain where you have used all these different types of 
normal forms in your project?
Me: Actually all this process is carried out by our project member. I was 
not involved in this process. So I don't know about it.
Int: Again asked me the same question for the fourth consecutive time.
Me: Here i become irritated with that question again.

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions


I've drawn the structure of the TCS building roughly, where our interviews 
are being conducted, and questioned him 'why you are maintaining all these 
departments in separate rooms why not a single big hall?'
Int:  Finally what do you want to become in TCS?
Me:  I want to become System Analyst within 3 to 4 years.
Int: will you become System Analyst immediately now?
Me: No No. Right now I came here for recruitment with TCS as a software 
programmer. But my goal for the next 3 to 4 years is to become System 
Analyst (SA).
Int:  Ok, can you tell the responsibilities of SA?
Me: As I'm a fresher, I don't know all the responsibilities of SA, but one 
of the  major responsibility is to analyze the system to be built and 
again analyzing the system after it is built to find whether it is meeting 
the client's requirements or not? Apart from this he may also involved in 
some more functions. But I'm unaware of them now.
Int: So, you want to become SA without knowing his responsibilities.
Me: I've nothing to say for this question and remained with blank face 
with this kind of his questions.
Int: So, it'll be difficult for you into TCS, anyway I wish you all the 
best.
Me: came out with complete dissatisfaction.

I was asked MR questions in HR interview and all HR questions in MR 
interview.

Everybody says that the interview will be cool. But some times  we may 
come across this kind of stress interviews. With this experience I'm not 
confident of being selected for TCS. Still the results are awaited. 

So friends don't be panic of interviews. It'll be very cool as everybody 
says. Very very rarely only we may come across such type of panel members. 
Even there you should not loose control on yourself. Here I've committed a 
biggest mistake by questioning the interviewer. Also in TCS, you can't 
expect only tech questions in tech round of interview and only HR 
questions in HR interview. Anything can be asked depending on the panel 
member.

TCS Placement Papers | TCS Interview Procedure | 
TCS Aptitude Questions | TCS Technical Questions | 
TCS Interview Questions



Goodluck to you all.