Computer Science
Differentiate between DDL and DML.
DDL & DML
3 Likes
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. |
Answered By
1 Like
Related Questions
What is the error in following statement ?
UPDATE EMPL ;Identify the error :
DELETE ALL FROM TABLE EMPL ;Consider the following SQL statement. What type of statement is this ?
CREATE TABLE employee (name VARCHAR, id INTEGER)- DML
- DDL
- DCL
- Integrity constraint
The data types
CHAR(n)andVARCHAR(n)are used to create ……………, and …………… length types of string/text fields in a database.- Fixed, equal
- Equal, variable
- Fixed, variable
- Variable, equal