Question

why do we generally execute a commit statement before beginning a transaction?
​

Answer 1

We use the transnational command to save changes invoked by a transaction to the database.

Explanation:

• This is the reason that we use commit statement in the SQL.

• It saves all the transactions until the last COMMIT or ROLLBACK command.

• Commit and rollback transactions are necessary to restore the changed data.

• This commit transaction makes the changes permanent in it.

Answer 2

Answer:

We Use Transnational command to save changes to invoked by a transaction to the database