Wikibooks: Informatics Practices for Class XI (CBSE)/More on DDL, DML and TCL
stub 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 datab...
Format: | Book |
---|---|
Language: | English |
Subjects: | |
Online Access: | https://en.wikibooks.org/wiki/Informatics_Practices_for_Class_XI_(CBSE)/More_on_DDL,_DML_and_TCL |
Summary: | stub 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. BookCat |
---|