Home » MCQs » SQL MCQs » SQL Commands: DDL, DML, DCL, TCL, DQL MCQs

Which of the following is TRUE about TCL?

20. Which of the following is TRUE about TCL?

1. Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
2. There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
3. Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
4. SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.

Answer: A) Transactions can be saved to the database and rolled back with the help of TCL commands in SQL

Explanation:

Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.