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

What does the COMMIT Statement do?

17. What does the COMMIT Statement do?

1. The data specified in this table or view is reported in this SQL statement.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. Specify the columns of the table in this SQL statement to return distinct values.
4. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.

Answer: B) Changes made in the SQL database transaction are permanently saved using this SQL statement

Explanation:

Changes made in the SQL database transaction are permanently saved using COMMIT SQL statement.