This question asked in CBSE SQP 2021
Write the full forms of DDL and DML. Write any two commands of DML in SQL.
Answer:
DDL stands for Data Definition Language.
DML stands for Data Manipulation Language.
2 DML commands: INSERT, UPDATE
Explanation:
- DDL(Data Definition Language) commands are used to create and modify the structure of a database and database objects.
|
DDL Command |
Description |
|
CREATE |
Used to create databases and tables |
|
ALTER |
Used to add, delete or edit columns and remove or create constraints in a table |
|
DESCRIBE |
Used to view the structure of an already created table |
|
DROP |
Used to permanently remove a database or a table from the system |
- DML(Data Manipulation Language) commands deal with the manipulation of data present in the database.
|
DML Command |
Description |
|
SELECT |
Used to retrieve data from a database |
|
INSERT |
Used to insert data into a table |
|
UPDATE |
Used to update existing data in a table |
|
DELETE |
Used to delete all record from a table |
