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

 

549 people joined Teachoo Black. What are you waiting for?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.