thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Transaction Control Language (TCL)

The SQL commands that manage transactions: BEGIN/START TRANSACTION, COMMIT, ROLLBACK and SAVEPOINT.

Definition

TCL statements group DML into atomic units of work and decide whether those changes become permanent. Many client tools run in autocommit mode, where each statement commits on its own unless a transaction is opened explicitly.

Example

BEGIN TRANSACTION; UPDATE ...; COMMIT;

Exam tip

COMMIT and ROLLBACK are TCL; candidates often misfile them under DML.

Related terms