Top 25 DBMS Questions Asked in Interviews for 2025
- April 25, 2025
Agar aap B.Tech, BCA ya MCA student ho ya kisi IT job ke interview ke liye prepare kar rahe ho, toh DBMS (Database Management System) ek important topic hai. Har technical interview mein isse related kuch na kuch zaroor poocha jaata hai.
Iss blog mein hum cover karenge Top 25 DBMS Interview Questions 2025 ke liye, simple aur asaan Hinglish mein – taaki aapko samajhne mein koi dikkat na ho.
Top 25 DBMS Interview Questions
1. What is DBMS?
DBMS ek software system hai jo data ko store, manage aur retrieve karta hai efficiently.
2. What is RDBMS ?
RDBMS (Relational DBMS) ek DBMS hai jisme data tables mein store hota hai aur relations ke through connect hota hai.
3. What is Primary Key?
Primary Key ek unique value hoti hai jo kisi row ko uniquely identify karti hai.
4. What is Foreign Key?
Foreign Key ek column hota hai jo kisi doosri table ki Primary Key ko refer karta hai.
5. What is Advantage of DBMS?
Data redundancy kam hoti hai
Data security badh jaati hai
Data access fast hota hai
6. What is Normalization ?
Normalization ek process hai jisse database ko efficiently design kiya jaata hai taaki data redundancy aur inconsistency kam ho.
7. What is First Normal Form (1NF)?
1NF mein sabhi attributes atomic (indivisible) hone chahiye.
8. What is SQL?
SQL (Structured Query Language) ek language hai jo database ke sath interact karne ke liye use hoti hai.
9. What is Difference Between DDL and DML?
DDL (Data Definition Language) – Tables create/update karne ke liye
DML (Data Manipulation Language) – Data insert/update/delete karne ke liye
10. What is ACID Properties?
A: Atomicity
C: Consistency
I: Isolation
D: Durability
Ye 4 properties ensure karti hain ki transaction safely complete ho.
11. What is Transaction ?
Transaction ek sequence of operations hoti hai jo ek unit ke roop mein execute hoti hai.
12. What is Index ?
Index ek database object hota hai jo search operations ko fast banata hai.
13. What is Views ?
View ek virtual table hoti hai jo SQL queries ke result ko represent karti hai.
14. What is Join in SQL?
Join ka use multiple tables ke data ko combine karne ke liye hota hai.
15. Types of Joins?
Inner Join
Left Join
Right Join
Full Join
16. What is Subquery ?
Subquery ek query hoti hai jo doosri query ke andar likhi jaati hai.
17. Difference between DELETE and TRUNCATE?
DELETE: Row-by-row delete karta hai
TRUNCATE: Saare rows ek baar mein delete karta hai (faster)
18. What is Cursor ?
Cursor ek database object hota hai jo row-by-row data access karta hai.
19. What is a Trigger?
Trigger ek automatic function hota hai jo kisi event par execute hota hai (e.g. INSERT, UPDATE).
20. What is a Schema?
Trigger ek automatic function hota hai jo kisi event par execute hota hai (e.g. INSERT, UPDATE).
21. What is a Stored Procedure?
Trigger ek automatic function hota hai jo kisi event par execute hota hai (e.g. INSERT, UPDATE).
22. What is a Deadlock in DBMS?
Jab do ya zyada transactions ek dusre ka resource hold karke wait karte hain, toh deadlock hota hai.
23. What is a Relational Algebra?
Relational Algebra ek theoretical language hai jo relational databases ko manipulate karne ke liye use hoti hai.
24. What is a Data Redundancy?
Jab same data multiple jagah stored hota hai, toh usse data redundancy kehte hain.
25. What is a Data Redundancy?
Rules hote hain jo data ki validity aur consistency maintain karte hain.