Q1. Different types of SQL statements?
DDL (CREATE, ALTER, DROP, TRUNCATE), DML (INSERT, UPDATE, DELETE, SELECT), DQL (SELECT — sometimes grouped with DML), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK, SAVEPOIN...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (5 available).
Active:
Tag: dml ×
Q2. DML includes?
**DML** stands for **Data Manipulation Language**. DML commands manage, insert, retrieve, and modify actual data rows stored inside database tables: ### Core DML Statemen...
Q3. Which is NOT a DML statement?
Statements such as **`COMMIT`**, **`ROLLBACK`**, **`CREATE`**, **`ALTER`**, and **`DROP`** are **NOT** DML statements: - `COMMIT` and `ROLLBACK` are **TCL (Transaction Co...
Q4. DELETE vs TRUNCATE?
See the comparison table above. Key differences: `DELETE` is DML (row-by-row, rollbackable, fires triggers, has WHERE). `TRUNCATE` is DDL (bulk page deallocation, faster,...
Q5. What is a trigger?
A stored procedure that automatically executes in response to a DML event (INSERT, UPDATE, DELETE) or DDL event (CREATE, ALTER, DROP). Components: **Event** (when), **Con...