TCS

TCS

Large multinational IT services and consulting enterprise based in India.

3 Rounds ~14 Days Medium
Start Mock Interview

The Interview Loop

Recruiter Screen (30 min)

Standard fit check, behavioral questions, and resume overview.

Technical Loop (3-4 Rounds)

Deep dive into domain knowledge, coding, and system design.

Interview Question Bank

Backend Engineer • Technical • easy

What is the difference between TRUNCATE, DELETE, and DROP in SQL?

#DDL #DML #Database Basics
Practice
Backend Engineer • Technical • medium

Explain indexing in relational databases. How does a B-Tree index work, and when should you NOT use an index?

#Database Optimization #Data Structures
Practice
Backend Engineer • Technical • medium

Write a SQL query to find all employees who earn more than their direct managers.

#Self Joins #Query Optimization
Practice
Data Engineer • Coding • medium

Write a SQL query to find the second highest salary in each department without using the MAX() function.

#SQL #Window Functions #Aggregations
Practice
Data Engineer • Coding • medium

How do you delete duplicate records from a massive table in SQL while keeping exactly one instance of each duplicate?

#SQL #Data Cleansing #CTEs
Practice
Data Engineer • Technical • medium

Explain the difference between a CTE and a Temporary Table. In a scenario where you are processing 50 million rows for a client report, which one would you choose and why?

#SQL #Performance Tuning #Database Architecture
Practice
Data Scientist • Coding • medium

Write a SQL query using window functions to find the top 3 highest spending customers in each region for a retail client.

#Window Functions #DENSE_RANK #PARTITION BY
Practice
Data Scientist • Coding • easy

Write a SQL query to find the employee who earns more than their direct manager.

#Self Join #SQL Queries
Practice
Data Scientist • Coding • medium

Write a SQL query to calculate the cumulative sum of revenue per month for the year 2023.

#Window Functions #Aggregations
Practice
Data Scientist • Coding • hard

Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT or TOP keywords.

#Subqueries #Correlated Subqueries
Practice
Full Stack Engineer • Coding • easy

Write a SQL query to find the second highest salary of an employee from a given department.

#SQL #Database #Queries
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to find the top 3 highest-grossing products in each category from a 'sales' table. Assume a standard enterprise retail schema.

#Window Functions #Aggregation #Data Engineering
Practice
Product Manager • Coding • hard

Write a SQL query to calculate the month-over-month churn rate for a SaaS product using a 'subscriptions' table.

#SQL #Churn #Window Functions
Practice
Product Manager • Coding • medium

Write a SQL query to find the top 5 enterprise clients by total API call volume in the last 30 days from an 'api_logs' table.

#SQL #Data Analysis #Aggregations
Practice
Software Engineer • Coding • medium

Write a SQL query to find the 3rd highest salary of an employee from the 'Employee' table without using the LIMIT keyword.

#SQL Queries #Subqueries #Database
Practice
Software Engineer • Coding • easy

Write a SQL query to find all duplicate rows in a table based on a specific column (e.g., email).

#GROUP BY #HAVING #Data Cleaning
Practice
Software Engineer • Technical • easy

Explain the exact differences between TRUNCATE, DELETE, and DROP commands in SQL.

#DDL #DML #Database Management
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now