Definition of DDL , DML , DCL , TCL

DDL : Full form of DDL is Data Definition Language. It is used to create and database objects in a database.Eg: CREATE, ALTER, DROP.

DML: Full form of DML is Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.Eg: INSERT, UPDATE, DELETE,SELECT.

DCL : Full form of DCL is Data Control Language. It is used to create and revoke roles & permissions. It is used to control access to database by allowing access only to the valid users . Eg: GRANT, REVOKE.

TCL : Full form of TCL is Transactional Control Language which is used to handle transactions occurring within the database.Eg: COMMIT, ROLLBACK and Save Point.

Pawan Kumar

Pawankkmr@hotmail.com

About these ads