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

From Wikibooks, open books for an open world
Jump to navigation Jump to search
  • 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.