Explain different languages present in DBMS.

1.	Explain different languages present in DBMS.
Answer» Following are various languages present in DBMS: DDL(DATA Definition Language): It contains commands which are required to define the database. E.g., CREATE, ALTER, DROP, TRUNCATE, RENAME, etc. DML(Data Manipulation Language): It contains commands which are required to manipulate the data present in the database. E.g., SELECT, UPDATE, INSERT, DELETE, etc. DCL(Data Control Language): It contains commands which are required to deal with the user permissions and controls of the database system. E.g., GRANT and REVOKE. TCL(TRANSACTION Control Language): It contains commands which are required to deal with the transaction of the database. E.g., COMMIT, ROLLBACK, and SAVEPOINT.

Answer»

Following are various languages present in DBMS:

DDL(DATA Definition Language): It contains commands which are required to define the database.
E.g., CREATE, ALTER, DROP, TRUNCATE, RENAME, etc.
DML(Data Manipulation Language): It contains commands which are required to manipulate the data present in the database.
E.g., SELECT, UPDATE, INSERT, DELETE, etc.
DCL(Data Control Language): It contains commands which are required to deal with the user permissions and controls of the database system.
E.g., GRANT and REVOKE.
TCL(TRANSACTION Control Language): It contains commands which are required to deal with the transaction of the database.
E.g., COMMIT, ROLLBACK, and SAVEPOINT.

Discussion