Which commands are considered TCL (Transaction Control Language) in Snowflake?

• A. Start, End, Cancel, Show Locks
• B. Begin, Commit, Rollback, Show Locks
• C. Begin, Commit, End, Show Queries
• D. Begin, End, Rollback, Show Locks

Answer: (B)

Transaction Control Language commands manage the lifecycle of a transaction: Begin starts a transaction, Commit applies the changes, and Rollback reverts them. The correct option includes all three of these TCL verbs—Begin, Commit, and Rollback—which is why it’s the best answer. The other choices replace these with non-TCL terms (Start, End, Cancel, etc.), which aren’t used to control transactions. The extra item shown, Show Locks, is a separate command used to view locks and isn’t part of TCL, but the essential TCL commands are the trio Begin, Commit, and Rollback.