MySQL Transaction Commands Quiz

What command is used to disable the autocommit mode in MySQL?

• SET autocommit = 0;

• SET autocommit = OFF;

• SET autocommit = 1;

• SET autocommit = ON;

What command is used to explicitly start a transaction in MySQL?

• BEGIN;

• START TRANSACTION;

• COMMIT;

• ROLLBACK;

What command is used to commit a transaction in MySQL?

• COMMIT;

• ROLLBACK;

• BEGIN;

• START TRANSACTION;

What command is used to roll back a transaction in MySQL?

• COMMIT;

• ROLLBACK;

• BEGIN;

• START TRANSACTION;

What happens when a transaction is committed using COMMIT;?

• All changes are canceled.

• All changes are permanently saved.

• The transaction is locked.

• The transaction is deleted.

What happens when a transaction is rolled back using ROLLBACK;?

• All changes are permanently saved.

• All changes are canceled.

• The transaction is locked.

• The transaction is deleted.

What command is used to check the status of the event scheduler thread in MySQL?

• SHOW EVENTS;

• SHOW PROCESSLIST;

• SHOW TRANSACTIONS;

• SHOW SCHEDULER;

What command is used to create a recurring event in MySQL?

• CREATE EVENT ... ON SCHEDULE AT ...

• CREATE EVENT ... ON SCHEDULE EVERY ...

• CREATE EVENT ... ON SCHEDULE ONCE ...

• CREATE EVENT ... ON SCHEDULE INTERVAL ...

What command is used to display all events in a MySQL database?

• SHOW EVENTS;

• SHOW PROCESSLIST;

• SHOW SCHEDULER;

• SHOW TRANSACTIONS;

What clause is used to preserve an event after it expires in MySQL?

• ON COMPLETION PRESERVE

• ON COMPLETION DELETE

• ON COMPLETION KEEP

• ON COMPLETION RETAIN