Savepoints within transactions in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a transaction.

SQL

BEGIN [1];

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

AROLLBACK

BSAVEPOINT

CCOMMIT

DTRANSACTION

Attempts:

3 left

💡 Hint

Common Mistakes

Using SAVEPOINT instead of TRANSACTION to start a transaction.

Using COMMIT or ROLLBACK to start a transaction.

To start a transaction in SQL, you use BEGIN TRANSACTION;.

2fill in blank

medium

Complete the code to create a savepoint named 'sp1'.

SQL

SAVEPOINT [1];

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

Astart

Bsp1

Ccommit

Drollback

Attempts:

3 left

💡 Hint

Common Mistakes

Using reserved words like COMMIT or ROLLBACK as savepoint names.

Using 'start' which is not the intended savepoint name.

Savepoints are named markers within a transaction. Here, sp1 is the savepoint name.

3fill in blank

hard

Fix the error in the code to rollback to the savepoint 'sp1'.

SQL

ROLLBACK TO [1];

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

Asp1

Bcommit

Cstart

Dbegin

Attempts:

3 left

💡 Hint

Common Mistakes

Using reserved words like COMMIT or BEGIN instead of the savepoint name.

Using a different savepoint name than the one created.

To rollback to a savepoint, use ROLLBACK TO sp1; where sp1 is the savepoint name.

4fill in blank

hard

Fill both blanks to release the savepoint named 'sp1' and then commit the transaction.

SQL

RELEASE [1];
COMMIT [2];

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

Asp1

BTRANSACTION

CSAVEPOINT

Dsp2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'SAVEPOINT' instead of 'TRANSACTION' after COMMIT.

Using a wrong savepoint name like 'sp2'.

To remove a savepoint, use RELEASE sp1;. To finish the transaction, use COMMIT TRANSACTION;.

5fill in blank

hard

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

SQL

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

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

ATRANSACTION

Bsp1

DSAVEPOINT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SAVEPOINT instead of TRANSACTION to start the transaction.

Using different names for savepoint creation and rollback.

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