Jump to content

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

From Wikibooks, open books for an open world
  • Ddl(data definition language): Deals with the structure(create,remove,or modify) of databases and tables. E.g. Create, Drop, alter.
  • Dml(data manipulation language):use to manipulate data/values within table e.g. insert, delete, update.
  • Dcl(data control language): use to control the access to the databases and tables e.g. Grant, revoke.
  • Tcl(transaction control language): use to control and manage transaction. E.g. Commit, rollback, savepoint.