Data Control Language (DCL) statements. Below have provided some examples of DCL.
GRANT: It has the ability to provide privileges to the user.
REVOKE: This statement have the facility to remove privileges provided by GRANT.
Transaction Control Statements (TCL) is used to handle the changes done by Data manipulation language.
COMMIT: This statement have the ability to commit data.
SAVEPOINT: This statement identifies point where we can roll back later.
ROLLBACK: This statement can done changes in the object to earlier state.
SET TRANSACTION: This statement can control the changes in the objects, we can commit or rollback objects as per the query requirement.