Explain the DDL and DML commands in sql with example?

Answer 1

DDL--Data Definition Language

and Commands for DDL as:

1.CREATE DATABASE--create a new data base

2.ALTER DATABASE---modifies a database

3.CREATE TABLE---create a new table

4.ALTER TABLE---modifies a table

5.DROP TABLE---deletes a table

6.CREATE INDEX---creates an index(search key)

7.DROP INDEX---deletes an index

DML---Data Manipulation Language

Commands from the DML part of SQL:

1.SELECT----extracts data from a database

2.UPDATE--updates data in a database

3.DELETE---deletes data from a database

4.INSERT INTO---insert new data into a database