

InterviewSolution
Saved Bookmarks
1. |
Definition of ddl and dml |
Answer» Data definition language (ddl) =it includes those commands which create, destroy, the table eg=alter table, create table, drop table..Data manipulation language(dml) =it includes all those commands which use to manipulate and manage data base eg= insert, select, delete, update etc...<br><th>BASIS FOR COMPARISON</th> <th>DDL</th> <th>DML</th> \t\t\tBasicDDL is used to create the database schema.DML is used to populate and manipulate databaseFull FormData Definition LanguageData Manipulation LanguageClassificationDDL is not classified further.DML is further classified as Procedural and Non-Procedural DMLs.CommandsCREATE, ALTER, DROP, TRUNCATE AND COMMENT and RENAME, etc.SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, etc.\t | |