How are SQL commands classified?
Answers
SQL COMMANDS ARE CLASSIFIED INTO:
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands.
Transactional control commands.
Classification of SQL demand:
There are basically five types of SQL demand.
DDL (Data Definition Language)
Data Definition Language or DDL commands are used for altering the structure of a table. In other words, DDL commands are proficient of creating, deleting, and modifying data.
DQL (Data Query Language)
DQL commands are used for appealing data from a relational database. There is only one command, which is the CHOICE command.
DML (Data Manipulation Language)
The DML or Data Manipulation Language commands help in amending a relational database.
DCL (Data Control Language)
In order to protect the information in a table from unlawful access, DCL commands are used.
TCL (Transaction Control Language)
Transaction Control Language commands can be used with DML commands.