Check sibling questions
Computer Science - Class 12
Chapter 9 - Structured Query Language

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

 

Learn Intergation from Davneet Sir - Live lectures starting soon!

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.