Computer scienceFundamentalsSQL and DatabasesBasics SQLTransaction Management

Understanding Transactions

Rollback

Report a typo

The bank_account table has columns named account_id (INT), account_balance (DECIMAL), and customer_loyalty(INT). Customer loyalty score is in the range of 0-10, with 10 being the highest loyalty score.

Choose a code of transaction that rolls back after trying to delete an account with a balance of 500.

Select one option from the list

START TRANSACTION; DELETE bank_account; ROLLBACK TRANSACTION;

START TRANSACTION; DELETE FROM bank_account WHERE account_balance = 500; COMMIT;

DELETE FROM bank_account WHERE account_balance = 500; ROLLBACK TRANSACTION;

START TRANSACTION; DELETE FROM bank_account WHERE bank_account.account_balance = 500; ROLLBACK;

___

Create a free account to access the full topic