TCS NQT Interview Experience

TECHNICAL:

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.

 



1) Which type of songs do you listen?

2) Why this type of song?

3) Asked about my projects in details. Asked me explain each of my project with diagram and code.

4) What is anomaly?

5) What are the types of anomalies? Explain with an example.

6) How to avoid anomalies?

7) DDL, DML commands

8) Drop, Delete and Truncate difference.

9) What is schema?

10) What is table definition?

11) What is namespace in python?

12) What is view?

13) One interviewer drew two tables and asked  me to write view query.

14) What is data redundancy?

15) How data redundancy can lead to data inconsistency? Explain with example.

16) He wrote one array and one intermediate step of merge sort algorithm, then he asked me to explain how “Merge” function will work after that step.

17) What is composite key and component key?

 

HR:

That HR guy grilled me a lot. He told me about the bond and service agreement, eligibility etc.

 

 

Write your Interview Experience or mail it to contribute@geeksforgeeks.org




My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.