Question 22Differentiate between DDL and DML. Mention the two commands for each category.

Question

Accepted Answer

Data Definition Language (DDL)Data Manipulation Language (DML)DDL provides a set of definitions to specify the storage structure and access methods used by the database system.DML is a language that enables users to access or manipulate data as organized by the appropriate data model.DDL commands are used to perform tasks such as creating, altering, and dropping schema objects. They are also used to grant and revoke privileges and roles, as well as for maintenance commands related to tables.DML commands are used to retrieve, insert, delete, modify data stored in the database.Examples of DDL commands are CREATE, ALTER, DROP, GRANT, ANALYZE etc.Examples of DML commands are INSERT, UPDATE, DELETE, SELECT etc.

Data Definition Language (DDL)	Data Manipulation Language (DML)
DDL provides a set of definitions to specify the storage structure and access methods used by the database system.	DML is a language that enables users to access or manipulate data as organized by the appropriate data model.
DDL commands are used to perform tasks such as creating, altering, and dropping schema objects. They are also used to grant and revoke privileges and roles, as well as for maintenance commands related to tables.	DML commands are used to retrieve, insert, delete, modify data stored in the database.
Examples of DDL commands are CREATE, ALTER, DROP, GRANT, ANALYZE etc.	Examples of DML commands are INSERT, UPDATE, DELETE, SELECT etc.

Review of Database Concepts & SQL — Question 33

Question 22