2. DBMS (Database Management System) Goal: Check your knowledge of databases, queries, and design. Common Topics: SQL Queries → SELECT, JOIN, GROUP BY, HAVING Normalization → 1NF, 2NF, 3NF Transactions → ACID properties Indexes → Types, usage, pros/cons ER Diagrams → Designing schemas Example Question: “Write an SQL query to find the 2nd highest salary from the Employee table.” “Explain the difference between INNER JOIN and LEFT JOIN.” “What are ACID properties in DBMS?” Tip: Even if you forget exact SQL syntax, explain the logic clearly.
