Question

What are the subsets of SQL?

Answer 1

The following are the four significant subsets of the SQL:

• Data definition language (DDL): It defines the data structure that consists of commands like CREATE, ALTER, DROP, etc.
• Data manipulation language (DML): It is used to manipulate existing data in the database. The commands in this category are SELECT, UPDATE, INSERT, etc.
• Data control language (DCL): It controls access to the data stored in the database. The commands in this category include GRANT and REVOKE.
• Transaction Control Language (TCL): It is used to deal with the transaction operations in the database. The commands in this category are COMMIT, ROLLBACK, SET TRANSACTION, SAVEPOINT, etc.