Question

Which of the following are TCL commands?

a) COMMIT and ROLLBACK

b) UPDATE and TRUNCATE

c) SELECT and INSERT

d) GRANT and REVOKE

Answer 1

TCL stands for Transaction Control Commands used for managing the changes made by DML commands like INSERT, DELETE, and UPDATE. The TCL commands are automatically committed in the database; that's why we cannot use them directly while creating tables or dropping them.

a) COMMIT and ROLLBACK