Multiple choice sql

Which one of the following comes under Transaction controlled Language ?

  1. grant

  2. revoke

  3. rollback

  4. none
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ROLLBACK is a Transaction Control Language (TCL) command that undoes transactions, while GRANT and REVOKE are Data Control Language (DCL) commands used for permissions. TCL includes COMMIT, ROLLBACK, and SAVEPOINT for managing database transactions.

AI explanation

Transaction Control Language (TCL) commands manage the effects of transactions on data, and ROLLBACK (along with COMMIT and SAVEPOINT) is one of the core TCL statements — it undoes the changes made in the current uncommitted transaction. GRANT and REVOKE, by contrast, belong to Data Control Language (DCL), since they manage user permissions rather than transaction state.

Keep practicing — related questions