DCL vs TCL

Total Post:23

Points:115

 2237  View(s)
Ratings:
Rate this:
  1. DCL vs TCL

    Here, we are giving the difference between DCL vs TCL. These difference are follows:


    DCL

    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.

    TCL

    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. 

Answer