TCS Digital Interview Experience (On-Campus)

There was a single interview round,
It was a combination of technical, managerial and HR round

Questions I was asked

• Write a random Join query and explain
• Write a SQL query for the second-highest salary
• How to remove redundancy from dbms
• Type of normal forms
• How will you optimise SQL queries?
• Difference between abstract class and interface
• How stacks and queues work
• How hashmap works
• Explain your projects
• Difference between C++ and Java
• Why TCS?
• Why should we hire you?
• Tell me your strength
• If you get a job offer from Microsoft, will you consider it?