Informatics Practices for Class XI (CBSE)/More on DDL, DML and TCL
Jump to navigation
Jump to search
 |
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.