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

Which command is used to check the current transaction status?

@@TRANSSTATE

@@TRANCOUNT

@@TRANSTATUS

@@TRANSACTION

2 / 20

What is the purpose of the @@ERROR function?

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

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

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

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

3 / 20

Which command is used to set the transaction isolation level?

SET ISOLATION LEVEL

SET TRANSACTION LEVEL

SET ISOLATION TRANSACTION

SET TRANSACTION ISOLATION LEVEL

4 / 20

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

ROLLBACK

REVERT

CANCEL

UNDO

5 / 20

What is the purpose of the XACT_ABORT setting in SQL Server?

To commit a transaction automatically

To start a new transaction

To save a transaction

To automatically roll back a transaction if an error occurs

6 / 20

Which isolation level allows dirty reads?

READ UNCOMMITTED

SERIALIZABLE

READ COMMITTED

REPEATABLE READ

7 / 20

Which isolation level prevents both dirty reads and non-repeatable reads?

READ COMMITTED

READ UNCOMMITTED

REPEATABLE READ

SERIALIZABLE

8 / 20

What is the function of an END TRY statement?

Ends the block of code being monitored for errors

Ends a transaction

Commits a transaction

Rolls back a transaction

9 / 20

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

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

Starts a new transaction

Commits a transaction

Rolls back a transaction

10 / 20

Which isolation level prevents dirty reads but allows non-repeatable reads?

READ UNCOMMITTED

REPEATABLE READ

READ COMMITTED

SERIALIZABLE

11 / 20

Which of the following commands is used to start a transaction in SQL Server?

OPEN TRANSACTION

START TRANSACTION

BEGIN TRANSACTION

INITIATE TRANSACTION

12 / 20

What does the RAISERROR statement do in SQL Server?

Generates an error message and initiates error processing

Commits a transaction

Starts a new transaction

Rolls back a transaction

13 / 20

Which isolation level provides the highest level of data consistency?

REPEATABLE READ

SERIALIZABLE

READ COMMITTED

READ UNCOMMITTED

14 / 20

What is the purpose of the BEGIN TRY statement?

To start a new transaction

To rollback a transaction

To start a block of code to monitor for errors

To commit a transaction

15 / 20

What is the purpose of the ROLLBACK TRANSACTION statement?

To start a new transaction

To undo all changes made during the transaction

To end the transaction without saving changes

To save all changes made during the transaction

16 / 20

What function returns the line number where an error occurred?

ERROR_POINT()

ERROR_POSITION()

ERROR_LINE()

ERROR_LOCATION()

17 / 20

What is a transaction in SQL Server?

A user-defined function

A system procedure

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

A type of database

18 / 20

What is the purpose of the SAVE TRANSACTION statement?

To set a savepoint within a transaction

To save all changes made during the transaction

To start a new transaction

To end the transaction without saving changes

19 / 20

What does the COMMIT statement do in a transaction?

Reverts all changes made during the transaction

Ends the transaction without saving changes

Starts a new transaction

Saves all changes made during the transaction

20 / 20

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

ERROR_SEVERITY()

ERROR_INTENSITY()

ERROR_LEVEL()

ERROR_GRADE()

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!