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