These are SQL questions of the kind TCS actually asks — the patterns that keep coming back in TCS's online tests and technical interview rounds for freshers. My advice: treat this page as a mock test. Attempt every question on paper first, then reveal. If any answer surprises you, the lesson it comes from is linked right below — go read it, then come back.
TCS SQL concept questions
What are the basic building blocks of ER (Entity-Relationship) modeling, and how do 1:1, 1:N, and M:N relationships typically map to relational tables?
Asked in
TCS SQL query questions
Using the same employees table, write a query to find all employees whose name starts with the letter 'A' and whose salary is greater than 50000, sorted by salary in descending order.
Asked in
employees9 rows
| emp_id | name | department | salary | manager_id | join_date | |
|---|---|---|---|---|---|---|
| 1 | Alice Sharma | Engineering | 95000 | NULL | 2019-03-12 | alice.sharma@corp.com |
| 2 | Bob Iyer | Engineering | 72000 | 1 | 2020-07-01 | bob.iyer@corp.com |
| 3 | Chitra Rao | Sales | 65000 | NULL | 2018-11-20 | chitra.rao@corp.com |
| 4 | David Paul | Sales | 58000 | 3 | 2021-01-15 | david.paul@gmail.com |
| 5 | Esha Nair | Engineering | 88000 | 1 | 2019-09-05 | esha.nair@corp.com |
| 6 | Farhan Khan | Marketing | 60000 | NULL | 2020-02-28 | farhan.khan@corp.com |
| 7 | Gita Menon | Marketing | 60000 | 6 | 2022-04-10 | gita.menon@gmail.com |
| 8 | Harish Verma | Sales | NULL | 3 | 2022-06-18 | harish.verma@corp.com |
| 9 | Amit Verma | Sales | 52000 | 3 | 2021-08-01 | amit.verma@corp.com |
Write an ALTER TABLE statement to add a new nullable column phone_number (VARCHAR(15)) to the existing students table, and a second ALTER TABLE statement to rename that column to contact_number.
Asked in
students2 rows
| student_id | name | |
|---|---|---|
| 1 | Ananya Gupta | ananya.g@example.com |
| 2 | Rohan Verma | rohan.v@example.com |
How to use this page: TCS rarely asks a question you've never seen — they ask standard patterns with a twist. Master the pattern in the SQL course lessons, and the twist stops mattering.
Keep practising: SQL Basics, Joins, GROUP BY & HAVING and Subqueries cover what most TCS SQL rounds test — and the TCS NQT exam guide covers the rest of their selection process.