Definition of DDL , DML , DCL , TCL

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s