Structured query language (SQL) is divided into two categories: data definition language (DDL) commands and data manipulation language (DML) commands. Data manipulation language (DML) is a set of commands that allows an end user to manipulate the data in the database ((Coronel & Morris, 2017). Example of Data manipulation language (DML) are select, insert, update, delete, commit, and rollback. Data definition language (DDL) is a language command set used to define data structures and modify data. Example of DDL commands are add, remove, or modify tables. There are used within in a database. DDLs used in database applications are considered a subset of SQL, the Structured Query Language. There are some major differences between DML and DDL. Furthermore, DDL is more flexible than DML. For example, it allows the developer to create more complex data definition languages such as data schemas, logical schemas, relationship schemas, user defined roles, and so on (Neha, 2021). With DML, it is only possible to use generic objects. On the other hand, DML is more flexible when it comes to working with complex database structures.

READ THE ABOVE. What do you agree and disagree with? What do you like or find interesting? What else might you add? Explain.

pur-new-sol

Related Questions