Class 12: SQL Questions 2

Data Definition Language
The DDL part of SQL permits database tables to be created or deleted. It contains necessary statements for creating, manipulating, altering and deleting tables.
Some of the DDL commands are :

CREATE DATABASE – Creates a new database.

CREATE TABLE : Creates a new table

ALTER TABLE : Modifies the definition of a table

DROP TABLE: Deletes a table

It is a part of SQL that helps user to access and manipulate data. It contains the statements to
* Insert data into the database
* Retrieve data from a database
* Delete data from a database
* Modify data in a database

DML commands are :
* SELECT statement
* INSERT INTO statement
* UPDATE statement
* DELETE statement

Commands:
* Commit
* Rollback