Question

what is DDL and DML​

Answer 1

Answer:

DDL is Define Definition Language used to define data structures.

DML is Data Manipulation Language used to manipulation itself.

Answer 2

Answer:

There are two types of languages:-

1. DDL (Data Definition Language)

2. DML (Data Manipulation Language)

Explanation:

DATA DEFINITION / DESCRIPTION LANGUAGE:- It is a standard for commands that define the different structures in a database. DDL statements create,modify and remove database objects such as tables, indexes and users.

Common DDL Statements are:-

1. Create :- Used to create database objects.

2. Alter :- Used to modify database objects.

3. Drop :- Used to delete database objects.

DATA MANIPULATION LANGUAGE:- It is a standard for commands that enables users to access and manipulate data in a database.

Common DML Statements are:-

1. SELECT :- Used for retrieval of information from the database.

2. INSERT :- Used for insertion of new information into the database.

3. DELETE :- Used for deletion of information in the database.

4. UPDATE :- Used for modification of information in the database.

Types of DML:-

1.Procedural:- The user specifies what data is needed and how to get it.

2. Non Procedural :- The user only specifies what data is needed.

Note:- A popular data manipulation language is SQL (Structured Query Language.)

Hey bro if ur studing for IT board use these notes it weill help u

class 10 IT blogspotcom  unit-7-database-development.

Im not advertising this is just a suggestion