MySQL + SQL · Lesson 124

DBMS Interview Questions

Common DBMS Interview Questions

Frequently asked DBMS questions with short answers — useful for placements and viva.

Question	Short Answer
What is DBMS?	Software to store, manage and retrieve data.
DBMS vs RDBMS?	RDBMS stores data in related tables with keys.
What is normalization?	Organizing tables to reduce redundancy.
Primary vs foreign key?	Primary = unique ID; foreign = link to another table.
What are ACID properties?	Atomicity, Consistency, Isolation, Durability.
DELETE vs TRUNCATE?	DELETE = rows with WHERE; TRUNCATE = all rows, faster.

Question	Short Answer
DBMS क्या है?	Data store, manage और retrieve करने वाला software।
DBMS बनाम RDBMS?	RDBMS data को keys वाली related tables में रखता है।
Normalization क्या है?	Redundancy घटाने के लिए tables organize करना।
Primary बनाम foreign key?	Primary = unique ID; foreign = दूसरी table से link।
ACID properties क्या हैं?	Atomicity, Consistency, Isolation, Durability।
DELETE बनाम TRUNCATE?	DELETE = WHERE वाली rows; TRUNCATE = सारी rows, तेज़।

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.

Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.