In the following transaction, what will happen if there is already an entry in the genre table with a genre$\_$id of $10?$

BEGIN;

INSERT INTO genre $($name$)$

VALUES $(2$ Zydeco'$)$;

UPDATE genre

SET genre$\_$id $=10$

WHERE genre $=$ 'Zydeco';

COMMIT;

Only the INSERT statement will be committed.

Neither of the statements in the transaction will be committed.

Both of the statements in the transaction will be committed.

Only the UPDATE statement will be committed.