Informatics Practices for Class XI (CBSE)/More on DDL, DML and TCL

Ddl(data definition language): Deals with the structure(create,remove,or modify) of databases and tables. E.g. Create,Drop ,alter.
Dml(data manupulation language):use to manupulate data/values within table e.g. insert,delete,update.
Dcl(data control language): use to control the acess to the databases and tables e.g. Grant,revoke.
Tcl(transaction control language): use to control and manage transaction. E.g. Commit,rollback,savepoint.

This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.