What is a DDL, DML and DCL concept in RDBMS world, in MS SQL Server?

Answer 1

DDL (Data definition language) defines our database structure. CREATE and ALTER are DDL statements as they affect the way our database structure is organized.
DML (Data Manipulation Language) lets we do basic functionalities like INSERT, UPDATE, DELETE and MODIFY data in database.
DCL (Data Control Language) controls you DML and DDL statements so that your data is protected and has consistency. COMITT and ROLLBACK are DCL control statements. DCL guarantees ACID fundamentals of a transaction.