my interview exp is very rare case, usual interview will focus on project and lost for around 25-30 min...basic idea on all mentioned subjects will do...take intrvw with full confidence..gud luck
Here is my interview experience with CTS held on 23rd sep - 6pm. Hope it gives u some idea .Have patience to read it ( bit elaborate ) like my 50 min long interview.
I was scheduled for interview at 3 pm on thursday. I reached there by 1 pm, had my lunch at foodcourt of CTS.only Rs.10 for vasantha bhavan meals worth Rs.40.
At 3 I was allowed to get into db2(Development block 2) where my interview held. till then we made to sit at the visitor waiting room near entrance.We filled up our HR form at ground floor HR office. At 4 divya(HR) called 2 people to interview room. (10 in 3pm batch only 8 turned). others were asked to wait at other HR section. At 4.15 my interviewer took myself and a girl to jp morgan development center at 4th floor. After waiting for other 15-20 min the girl got call and i was asked to stay there. She was interviewed for around 50 min and then i got call. At that time most of the employees are leaving after work. My interviewer came to my room and called me saying sorry for the long wait. I said its cool here waiting in an A/C room than the sultry outside. He smiled at me and i got into interview room by 6pm. There r 2 in my panel.
To say abt interviewer they introduced themselves. I introduced myself with a firm handshake. My first question is introduce urself. I said abt schooling, family, hobby..Here starts my tech section with questions fired with no gap between my answer and next question. Interviewer seems very strong (sariyana mandai) in all areas. I said my area of interest as OS, networking. I got qs frm C, SQL, OS, DBMS, Networks, OOPs, Microprocessor...
TECH QUESTIONS that i remember:
What is an OS?
Types of OS?
Deadlock? Deadlock detection?
what is batch file?
how virtual memory implemented?
Memory leakage?(i said its something deals with memory wastage but no idea sir)
Semaphore? P() v() conditions..
u designed ur college website did u know j2ee, scripting? ( I have no idea abt j2ee I used tools to design a website)
What tools (dream weaver,fireworks)
Whats ur college site address ( our old college site is not yet updated with mine but one I designed is at www.adhiparasakthienggcollege.tk)
What is Datastructure?
which is FIFO and LIFO ? (queue and stack respectively)
Types of sorting?
Explain heap sort?
y link list rather than array?
(my ans is - max memory usage through pointers in link list, easy to insert and delete)
What is normalisation?
-i explained first normal form he said proceed with 2nd,3rd,BCNF,fourth normal form...i said all but confused abt fifth normal form..)
What is RDBMS and compare with DBMS?
what is open system in network?
( system which has nodes communicate independent of underlying architecture)
what is a microprocessor? (my ans-a programmable electronic device with memory and processes input data)
What is OPCODE?
Diff between C & C++?
which is faster c r c++?
What is a JOIN
types of join
explain equi join?
what i in oracle8i stands for ? internet
i may left some questions but every questions r fundamentals only.
No questions on Proj as mine is an application in VC++.
No question frm Software engg (for me)
PROGRAMS AND SQL
While i am answering tech questions simultaneously he wrote questions in a sheet
1. Swap two nos without third var(temp)
2.Example for operator overloading
3.example for Multiple inheritance
he drawed two tables emp and dept and asked for
4.Find the nth max frm sal in emp table? ( i tried with MAX() in sql but couldnt get it right)
5.equijoin emp and dept table
6.Left and right join emp and dept table
( I said i lost in touch with SQL but tried)
Then started my HR questions same person. The person who called me was silent but noting down something on a sheet while other firing questions in a very fast phase..as it is 6.45 pm then.
HR: U wrote ur short term plan as learning but I need a proper thing r ur career plan
I: for first sixth month I may be in trainee later would be an analyst.
HR: Long term..
I : Willing to pursue my magerial degree and to promote to managerial position in next five years.
HR: ur hobby is cooking, browsing and reading magazines. What kind of magazines and sites
I : Riders digest,India today,The week, and anada vikatan etc.,
HR: Regarding sites state a few
I : santabanta for entertainment, Times of India.com for news, W3schools.com for tutorials,webopedia.com for tech terms,google and a9.com for searching.
WHAT u did for last 4 months?
( i applied for more than 80 companies and took written for infosys,ibm,CTS,iGATE,L-cube and i went upto hr interview in iGATE.)
-its lie actually i got placed in igate in june16 selection at easwari engg college walkin and got my joining date last week as MARCH 2 2005.yes another 5 months to go.So is the answer.Dont say if u got offer frm any other firms.
Say me abt CTS?
blah blah info frm www.cognizant.com
CEO of CTS?
I want to celebrate work
HR: What is the Latest tech in IT?
I : The latest tech which hogs limelight is J2ee and datawarehousing
HR: I asked technology ..
I : RFID - Radio frequency identification and explained in a few lines
HR: Latest News
I : I said abt umabharti issue, US visit of pm, windies match, jayalakshmi issue...
I read last weeks THEWEEK cover story of sunset of Silicon Valley? abt IT companies are now in mood of moving to Chennai,pune rather than bangalore..(he was impressed)
HR : did pm met bush r blair
I : I said I got confused sir I am not clear as both pm and president on tour.(he laughs)
That's it ..Its 7 when I came out of interview room.
Results would be announced on sat 25 sep by mail. My hopes r high for a positive result.I answer almost all questions but couldnt answer 3 sql questions alone but tried. I am praying. Hope I covered all possible information.
TIPS : Be concise in answer as questions r linked frm ur answer. Don't worry if u do know any.They look into ur overall performance. DON'T PANIC. Not all will have such a long session of interview. It happens sometimes be prepared .Don't settle with area of interest alone. Be confident.