Search Header Logo

MySQL Transaction Commands Quiz

Authored by saad ben

Information Technology (IT)

University

MySQL Transaction Commands Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

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

SET autocommit = 0;

SET autocommit = OFF;

SET autocommit = 1;

SET autocommit = ON;

2.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

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

BEGIN;

START TRANSACTION;

COMMIT;

ROLLBACK;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What command is used to commit a transaction in MySQL?

COMMIT;

ROLLBACK;

BEGIN;

START TRANSACTION;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

COMMIT;

ROLLBACK;

BEGIN;

START TRANSACTION;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SHOW EVENTS;

SHOW PROCESSLIST;

SHOW TRANSACTIONS;

SHOW SCHEDULER;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?