Informatics Practices for Class XI (CBSE)/More on DDL, DML and TCL
This page or section is an undeveloped draft or outline. You can help to develop the work, or you can ask for assistance in the project room. |
- 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.