Question 7Differentiate between commit() and rollback() statements.

Question

Accepted Answer

commit() statementrollback() statementThe commit() method is used to permanently save the changes made during a transaction to the database.The rollback() method is used to undo or revert the changes made by a transaction.The syntax is: connection.commit().The syntax is: connection.rollback().

commit() statement	rollback() statement
The commit() method is used to permanently save the changes made during a transaction to the database.	The rollback() method is used to undo or revert the changes made by a transaction.
The syntax is: `connection.commit()`.	The syntax is: `connection.rollback()`.

Interface Python with SQL — Question 7

Question 7