No products in the cart.

Difference between DML and DDL

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Difference between DML and DDL
  • 1 answers

Sia ? 3 years, 6 months ago

<th>DDL</th> <th>DML</th>
It stands for Data Definition Language. It stands for Data Manipulation Language.
It is used to create database schema and can be used to define some constraints as well. It is used to add, retrieve or update the data.
It basically defines the column (Attributes) of the table. It add or update the row of the table. These rows are called as tuple.
It doesn’t have any further classification. It is further classified into Procedural and Non-Procedural DML.
Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc. BASIC command present in DML are UPDATE, INSERT, MERGE etc.
DDL does not use WHERE clause in its statement. While DML uses WHERE clause in its statement.
http://mycbseguide.com/examin8/

Related Questions

Types of e-commerce fraud
  • 0 answers
5 uses of mouse
  • 0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App