🅢Here are the 10 most critical SQL questions that dominate both academic exams and job interviews. I’ve structured them with the exact concepts you must mention and sample syntax to ace the practical round. 1. What are the 4 categories of SQL commands (DDL, DML, DCL, TCL)? Concept to highlight: Distinguish by their impact on database structure vs. data vs. permissions vs. transactions. · DDL (Data Definition): CREATE, ALTER, DROP, TRUNCATE (Auto-commits). · DML (Data Manipulation): SELECT, INSERT, UPDATE, DELETE (Requires COMMIT). · DCL (Data Control): GRANT, REVOKE (User permissions). · TCL (Transaction Control): COMMIT, ROLLBACK, SAVEPOINT. --- 2. Explain all SQL JOINs with a real-world use case. Concept to highlight: How data is matched between tables. · INNER JOIN: Returns only matching rows in both tables. · LEFT/RIGHT JOIN: Returns all rows from the left/right table + matches from the other (NULL if no match). · FULL OUTER JOIN: Returns all rows from...