Tcs placement Paper --18 November 2006 --- Hyderabad.



Tcs placement Paper --18 November 2006 --- Hyderabad...

Answer / smiley

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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Placement Papers Interview Questions

Aricent Interview ,Written test -- Delhi On 21 jan 2007

2 Answers   Aricent, Flextronics,


SBI latest question papers

12 Answers   State Bank Of India SBI,


If anybody knows the recruitment procedure of IOTL & POWER MECHANICAL. send me the placement papers if u hav... very urgent ...

0 Answers   Electrical Tech, TCS,


email me previous question papers of bob bank for po exams

0 Answers   CMS,


IFLEX Placement Paper { Mohali ,10 May 2007}

2 Answers   AIG, iFlex,






Consagous Selection Procedure

1 Answers   Consagous,


interview questions

1 Answers   Cognizant, CTS, IGCAR,


consagous technologies placement papers

1 Answers   Consagous,


group2 non_excutive posts results

0 Answers   APPSC,


sir,did u send me hpcl syllabus for engg. disiplience & previous year question paper for electrical & electronic.

1 Answers   HPCL,


TISL PLACEMENT PAPERS -------------- Placement Paper 3

1 Answers   TISL,


TISL PLACEMENT PAPERS -------------- Placement Paper 8

1 Answers   TISL,


Categories