Core Concept Mastery • DBMS Module
Think of a Construction Site.
DDL (Data Definition - The Architect): Builds the walls, floors, and rooms. (CREATE, ALTER, DROP, TRUNCATE).
DML (Data Manipulation - The Interior Designer): Puts furniture inside the rooms. Doesn't touch the walls, just moves the stuff inside. (INSERT, UPDATE, DELETE).
DCL (Data Control - The Security): Decides who gets the keys to enter the house. (GRANT, REVOKE).
TCL (Transaction Control - The Manager): Signs off on the work. "Okay, this room is finished, Save it." (COMMIT, ROLLBACK).
It helps to know intent. If you use DDL, you are changing the ARCHITECTURE. If you use DML, you are changing the RECORDS.
DDL = "Build a Garage" (CREATE). DML = "Park the Car" (INSERT). DCL = "Give Keys" (GRANT). TCL = "Save Game" (COMMIT).
"TRUNCATE is which type of command?"
DDL (Data Definition Language).