BEGIN TRANSACTION syntax in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a transaction in SQL.

SQL

[1];

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

ACOMMIT TRANSACTION

BBEGIN TRANSACTION

CROLLBACK TRANSACTION

DSAVE TRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using COMMIT TRANSACTION to start a transaction.

Using ROLLBACK TRANSACTION instead of BEGIN TRANSACTION.

The BEGIN TRANSACTION statement starts a new transaction block in SQL.

2fill in blank

medium

Complete the code to start a transaction and ensure changes can be undone if needed.

SQL

[1]; -- start transaction

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

ACOMMIT TRANSACTION

BSAVE TRANSACTION

CROLLBACK TRANSACTION

DBEGIN TRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using SAVE TRANSACTION to start a transaction.

Using COMMIT TRANSACTION at the start.

BEGIN TRANSACTION starts the transaction so changes can be committed or rolled back later.

3fill in blank

hard

Fix the error in this SQL code that tries to start a transaction.

SQL

BEGIN [1];

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

AROLLBACK

BCOMMIT

CTRANSACTION

DSAVE

Attempts:

3 left

💡 Hint

Common Mistakes

Using BEGIN COMMIT instead of BEGIN TRANSACTION.

Using BEGIN ROLLBACK which is invalid.

The correct syntax to start a transaction is BEGIN TRANSACTION.

4fill in blank

hard

Fill both blanks to correctly start and then commit a transaction.

SQL

[1];
-- some SQL statements
[2];

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

ABEGIN TRANSACTION

BCOMMIT TRANSACTION

CROLLBACK TRANSACTION

DSAVE TRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using ROLLBACK TRANSACTION instead of COMMIT TRANSACTION to save changes.

Not starting with BEGIN TRANSACTION.

First, start the transaction with BEGIN TRANSACTION. After your SQL statements, use COMMIT TRANSACTION to save changes.

5fill in blank

hard

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

SQL

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

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

ABEGIN TRANSACTION

Bsp1

DCOMMIT TRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using different names for savepoint and rollback.

Using COMMIT TRANSACTION instead of BEGIN TRANSACTION at start.

Start with BEGIN TRANSACTION. Then create a savepoint named sp1. Finally, rollback to that savepoint using its name.