SQL Server Transactions and Error Handling – Intermediate-Level Quiz

SQL Server Transactions and Error Handling - Intermediate-Level Quiz

This intermediate-level quiz will challenge your understanding of transactions and error handling in SQL Server. Test your knowledge on how to manage transactions, ensure data integrity, and handle errors effectively. The quiz is ideal for those with a solid grasp of SQL Server basics and looking to deepen their expertise.

1 / 20

What is the purpose of the ROLLBACK TRANSACTION statement?

To start a new transaction

To undo all changes made during the transaction

To save all changes made during the transaction

To end the transaction without saving changes

2 / 20

Which function returns the name of the stored procedure or trigger where an error occurred?

ERROR_ROUTINE()

ERROR_PROCEDURE()

ERROR_TRIGGER()

ERROR_FUNCTION()

3 / 20

What is a transaction in SQL Server?

A type of database

A system procedure

A user-defined function

A single unit of work that is either fully completed or fully rolled back

4 / 20

What does the COMMIT statement do in a transaction?

Reverts all changes made during the transaction

Starts a new transaction

Saves all changes made during the transaction

Ends the transaction without saving changes

5 / 20

What is the purpose of the SAVE TRANSACTION statement?

To start a new transaction

To set a savepoint within a transaction

To save all changes made during the transaction

To end the transaction without saving changes

6 / 20

What function returns the line number where an error occurred?

ERROR_LINE()

ERROR_LOCATION()

ERROR_POINT()

ERROR_POSITION()

7 / 20

What is the purpose of the BEGIN TRY statement?

To commit a transaction

To rollback a transaction

To start a new transaction

To start a block of code to monitor for errors

8 / 20

Which isolation level provides the highest level of data consistency?

SERIALIZABLE

READ UNCOMMITTED

REPEATABLE READ

READ COMMITTED

9 / 20

What is the function of an END TRY statement?

Commits a transaction

Rolls back a transaction

Ends the block of code being monitored for errors

Ends a transaction

10 / 20

Which function returns the error number in a CATCH block?

ERROR_VALUE()

ERROR_CODE()

ERROR_NUMBER()

ERROR_ID()

11 / 20

What is the purpose of the SAVEPOINT statement in a transaction?

To end the transaction

To start a new transaction

To commit a part of the transaction

To set a point within a transaction to which you can later roll back

12 / 20

What is the purpose of the @@ERROR function?

To return the error message of the last Transact-SQL statement executed

To return the error state of the last Transact-SQL statement executed

To return the error number of the last Transact-SQL statement executed

To return the error severity of the last Transact-SQL statement executed

13 / 20

Which of the following functions returns the severity level of an error?

ERROR_INTENSITY()

ERROR_LEVEL()

ERROR_GRADE()

ERROR_SEVERITY()

14 / 20

Which isolation level allows dirty reads?

READ COMMITTED

REPEATABLE READ

SERIALIZABLE

READ UNCOMMITTED

15 / 20

Which command is used to set the transaction isolation level?

SET ISOLATION LEVEL

SET ISOLATION TRANSACTION

SET TRANSACTION ISOLATION LEVEL

SET TRANSACTION LEVEL

16 / 20

What is the purpose of the SET XACT_ABORT ON statement in SQL Server?

To start a new transaction

To automatically roll back the transaction if a Transact-SQL statement raises a run-time error

To commit the transaction automatically

To save the transaction

17 / 20

What does the TRY...CATCH construct do in SQL Server?

Rolls back a transaction

Commits a transaction

Starts a new transaction

Handles errors by transferring control to a CATCH block if an error occurs

18 / 20

What is the purpose of the END CATCH statement?

To commit a transaction

To end a transaction

To end the block of code-handling errors

To rollback a transaction

19 / 20

What is the purpose of the BEGIN CATCH statement?

To commit a transaction

To start a new transaction

To start a block of code to handle errors

To rollback a transaction

20 / 20

Which statement is used to undo changes made during a transaction?

REVERT

ROLLBACK

UNDO

CANCEL

Your score is

The average score is 42%

Think you know SQL Server transactions inside out? How about error-handling techniques? Put your SQL Server transactions and error handling skills to the test with this quiz crafted specifically for intermediate users like you.

Explore advanced concepts and discover best practices that can significantly impact your database solutions. Challenge yourself now and unlock new insights.

Good luck!