List any two DDL and DML commands with its Syntax?

1.	List any two DDL and DML commands with its Syntax?
Answer» Commands: 1. CREATE 2. DROP Syntax: 1. CREATE database databasename 2. DROP database databasename DML COMMANDS List: Commands: 1. INSERT 2. DELETE Syntax: 1. Syntax 1: INSERT INTO tablename (column1, column2, column3) VALUES (value 1, value2, value3); 2. Syntax 2: INSERT INTO tablename VALUES (value1, value2, value3); 3. DELETE from tablename WHERE columnname= ”value”;

Answer»

Commands:

1. CREATE

2. DROP

Syntax:

1. CREATE database databasename

2. DROP database databasename

DML COMMANDS List:

Commands:

1. INSERT

2. DELETE

Syntax:

1. Syntax 1: INSERT INTO tablename (column1, column2, column3) VALUES (value 1, value2, value3);

2. Syntax 2: INSERT INTO tablename VALUES (value1, value2, value3);

3. DELETE from tablename WHERE columnname= ”value”;

Discussion