---
title: "DCL vs TCL"  
description: "DCL vs TCL"  
author: "Anupam Mishra"  
published: 2016-05-01  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/23008/dcl-vs-tcl  
category: "database"  
tags: ["database"]  
reading_time: 2 minutes  

---

# 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.

## Answers

### Answer by Anupam Mishra

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.


---

Original Source: https://www.mindstick.com/interview/23008/dcl-vs-tcl

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.