interview

home / developersection / interviews / dcl vs tcl

Ask Question
Anupam Mishra

Other

Message
Can you answer this question?
Answer

1 Answers

Anupam Mishra

Anupam Mishra

01-May-2016
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. 
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy