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.

Question

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.

Micron Technology