Transaction states in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a transaction in SQL.

DBMS Theory

BEGIN [1];

Drag options to blanks, or click blank then click option'

ATRANSACTION

BCOMMIT

CROLLBACK

DSAVEPOINT

Attempts:

3 left

💡 Hint

Common Mistakes

Using COMMIT or ROLLBACK to start a transaction instead of BEGIN TRANSACTION.

Omitting the word TRANSACTION after BEGIN.

To start a transaction in SQL, you use BEGIN TRANSACTION. This marks the start of a transaction block.

2fill in blank

medium

Complete the code to save a transaction permanently.

DBMS Theory

[1];

Drag options to blanks, or click blank then click option'

ASAVEPOINT

BCOMMIT

CROLLBACK

DBEGIN TRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using ROLLBACK instead of COMMIT to save changes.

Forgetting to commit after making changes.

The COMMIT command saves all changes made during the transaction permanently to the database.

3fill in blank

hard

Fix the error in the code to undo changes in a transaction.

DBMS Theory

[1] TRANSACTION;

Drag options to blanks, or click blank then click option'

ABEGIN

BCOMMIT

CSAVEPOINT

DROLLBACK

Attempts:

3 left

💡 Hint

Common Mistakes

Using COMMIT instead of ROLLBACK to undo changes.

Using BEGIN TRANSACTION instead of ROLLBACK.

The ROLLBACK command undoes all changes made in the current transaction, reverting the database to its previous state.

4fill in blank

hard

Fill both blanks to create a savepoint and rollback to it.

DBMS Theory

SAVEPOINT [1];
ROLLBACK TO [2];

Drag options to blanks, or click blank then click option'

Asp1

Bsp2

Csave1

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using different names for savepoint and rollback.

Using reserved words as savepoint names.

A savepoint is named (e.g., sp1) and you can rollback to that exact point using ROLLBACK TO sp1.

5fill in blank

hard

Fill all three blanks to start a transaction, create a savepoint, and rollback to it.

DBMS Theory

BEGIN [1];
SAVEPOINT [2];
ROLLBACK TO [3];

Drag options to blanks, or click blank then click option'

ATRANSACTION

Bsp_save

DSAVEPOINT

Attempts:

3 left

💡 Hint

Common Mistakes

Using different names for savepoint and rollback.

Omitting TRANSACTION after BEGIN.

Using SAVEPOINT keyword incorrectly.

First, start the transaction with BEGIN TRANSACTION. Then create a savepoint named sp_save. Finally, rollback to that savepoint with ROLLBACK TO sp_save.