InterviewPitch
Land the job you want — prepare
with Real interviews Q&A
Curated interview questions, company-wise guides and coding rounds. Practice mock interviews, improve with feedback, and track your progress.
Q&A
Top curated interview packs
Company-wise & role-wise packs, quality assured.
Mock interview
AI scoring
Coding rounds
Top 10 sets
Beginner
1. What is SQL?
SQL (Structured Query Language) is used to store, retrieve, update, and manage data in relational databases.
Beginner
2. What are databases?
A database is an organized collection of data that can be easily accessed, managed, and updated.
Beginner
3. What are SQL commands?
SQL commands are instructions used to communicate with a database like SELECT, INSERT, UPDATE, DELETE.
Beginner
4. What is a table?
A table stores data in rows and columns within a database.
Beginner
5. What is a primary key?
A primary key uniquely identifies each record in a table and cannot be NULL.
Beginner
6. What is a foreign key?
A foreign key creates a relationship between two tables by referencing a primary key.
Beginner
7. What is NULL?
NULL represents missing or unknown data in a column.
Beginner
8. What is SELECT?
Used to retrieve data from one or more tables.
Beginner
9. What is WHERE clause?
Filters records based on specified conditions.
Beginner
10. What is DISTINCT?
Removes duplicate records from query results.
Beginner
11. What is ORDER BY?
Sorts query results in ascending or descending order.
Beginner
12. What is INSERT?
Adds new records to a table.
Beginner
13. What is UPDATE?
Modifies existing records in a table.
Beginner
14. What is DELETE?
Removes records from a table.
Beginner
15. What is TRUNCATE?
Deletes all records from a table quickly and permanently.
Intermediate
16. Difference between DELETE and TRUNCATE?
DELETE is rollbackable.TRUNCATE is faster and cannot be rolled back.
Intermediate
17. What are joins?
Joins combine rows from multiple tables using a related column.
Intermediate
18. Types of joins?
INNER, LEFT, RIGHT, FULL JOIN.
Intermediate
19. What is GROUP BY?
Groups rows with same values and works with aggregate functions.
Intermediate
20. What is HAVING?
Filters grouped records (used with GROUP BY).
Intermediate
21. What are aggregate functions?
Functions like COUNT, SUM, AVG, MIN, MAX.
Intermediate
22. What is an index?
Improves query performance by speeding up data retrieval.
Intermediate
23. What is a view?
A virtual table created using a SELECT query.
Intermediate
24. What is normalization?
Process of reducing data redundancy by organizing tables.
Intermediate
25. What is denormalization?
Combining tables to improve read performance.
Advanced
31. What is a stored procedure?
A precompiled SQL code stored in the database for reuse.
Advanced
32. What is a trigger?
Automatically executes SQL code when an event occurs.
Advanced
33. What is a transaction?
A sequence of operations performed as a single logical unit.
Advanced
34. What are ACID properties?
Atomicity, Consistency, Isolation, Durability.
Advanced
35. What is a deadlock?
When two transactions wait indefinitely for each other.
Coding Round
41. Select top 5 records
SELECT * FROM table_name LIMIT 5;Coding Round
42. Find duplicate records
SELECT col, COUNT(*) FROM table GROUP BY col HAVING COUNT(*) > 1;Coding Round
43. Second highest salary
SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM emp);Coding Round
44. Count records in table
SELECT COUNT(*) FROM table_name;Coding Round
45. Delete duplicate rows
Use ROW_NUMBER() with CTE.
Coding Round
46. Fetch records between dates
SELECT * FROM orders WHERE date BETWEEN '2024-01-01' AND '2024-12-31';Coding Round
47. Update multiple rows
UPDATE table SET status='Active' WHERE role='User';Coding Round
48. Find NULL values
SELECT * FROM table WHERE column IS NULL;Coding Round
49. Rename a column
ALTER TABLE table_name RENAME COLUMN old TO new;Coding Round
50. Difference between UNION and UNION ALL
UNION removes duplicates.UNION ALL keeps duplicates.