TCS Interview Question

What is DML? Give some basic DML commands?

Interview Answer

Anonymous

Jul 24, 2026

ML (Data Manipulation Language) is used to manipulate the data stored in database tables. It operates on rows rather than the database structure. The main DML commands are SELECT (retrieve data), INSERT (add data), UPDATE (modify data), and DELETE (remove data). These commands are typically transactional, meaning their changes can often be rolled back before the transaction is committed. TRUNCATE removes all rows from a table without a WHERE clause. It is a DDL command in most databases, is much faster than DELETE, and usually resets the identity counter while preserving the table structure. DROP removes the entire table, including its data, structure, indexes, and constraints. After DROP, the table no longer exists.