TCS Interview Experience
Technical Round:
After Clearing TNQT 2020, I got an interview call from TCS at Gitanjali Park Kolkata. In my panel, there were two panelists (probably TR and MR) but both asked me from Technical.
- Which type of songs do you listen?
- Why this type of song?
- Asked about my projects in details. Asked me to explain each of my projects with diagram and code.
- What is an anomaly?
- What are the types of anomalies? Explain with an example.
- How to avoid anomalies?
- DDL, DML commands
- Drop, Delete and Truncate difference.
- What is schema?
- What is table de<ni=on?
- What is namespace in Python?
- What is the view?
- One interviewer drew two tables and asked me to write the view query.
- What is data redundancy?
- How data redundancy can lead to data inconsistency? Explain with example.
- He wrote one array and one intermediate step of a merge sort algorithm, then he asked me to explain how “Merge” func=on will work after that step.
HR Round: That HR guy grilled me a lot. He told me about the bond and service agreement, eligibility, etc. Then he asked me why I will not go for CTS and why TCS? CTS was giving higher package than TCS (He knew there was a CTS drive in our college before TCS interview). In this topic, only 20 minutes went. Worst HR experience ever.