Questions realted Database management System faces in interview of 2021 - 2022:

	RDBMS -> MYSQL

Basic

• Explain DBMS
• Different languages in DBMS (DDL, DML, DCL, TCL with Example)
• ACID properties in DBMS with real life example (Very Important)
• Data abstraction in a DBMS
• Types of Join
• Difference between JOIN and UNION

Intermediate

• What is a lock in DBMS and types
• Keys in DBMS
• Ready with keywords like - DELETE, DROP, DISTINCT, GROUP BY, ORDER BY, VIEW
• Find nth largest salary in Employee data
• LIMIT and sub-query

Advance

• Normalization and Denormalization
• Different tier architecture in a DBMS
• Ready with FOREIGN KEY and Multiple JOIN related queries
• Some Apps like Instagram, data fetching query and database design part

If you find the post useful. Please upvote ;)
Comment for better reach
Fell Free to ask Anything