Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the ROLLBACK Statement do?

18. What does the ROLLBACK Statement do?

1. Specify the columns of the table in this SQL statement to return distinct values.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. An index is created in a SQL database table with this SQL statement.

Answer: C) By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone

Explanation:

By running ROLLBACK SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.