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 isolation level prevents both dirty reads and non-repeatable reads?

READ COMMITTED

REPEATABLE READ

READ UNCOMMITTED

SERIALIZABLE

2 / 20

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

ROLLBACK

CANCEL

UNDO

REVERT

3 / 20

What is the purpose of the SAVE TRANSACTION statement?

To end the transaction without saving changes

To start a new transaction

To save all changes made during the transaction

To set a savepoint within a transaction

4 / 20

Which function returns the error number in a CATCH block?

ERROR_CODE()

ERROR_ID()

ERROR_VALUE()

ERROR_NUMBER()

5 / 20

Which function returns the state number of an error?

ERROR_PHASE()

ERROR_CONDITION()

ERROR_STATUS()

ERROR_STATE()

6 / 20

What is the purpose of the BEGIN TRY statement?

To start a block of code to monitor for errors

To rollback a transaction

To start a new transaction

To commit a transaction

7 / 20

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

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

Rolls back a transaction

Commits a transaction

Starts a new transaction

8 / 20

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

To start a new transaction

To save a transaction

To commit a transaction automatically

To automatically roll back a transaction if an error occurs

9 / 20

Which command is used to set the transaction isolation level?

SET TRANSACTION ISOLATION LEVEL

SET ISOLATION TRANSACTION

SET TRANSACTION LEVEL

SET ISOLATION LEVEL

10 / 20

What is the purpose of the BEGIN CATCH statement?

To start a new transaction

To rollback a transaction

To commit a transaction

To start a block of code to handle errors

11 / 20

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

ERROR_SEVERITY()

ERROR_LEVEL()

ERROR_GRADE()

ERROR_INTENSITY()

12 / 20

Which isolation level provides the highest level of data consistency?

REPEATABLE READ

SERIALIZABLE

READ UNCOMMITTED

READ COMMITTED

13 / 20

What is the function of an END TRY statement?

Rolls back a transaction

Ends a transaction

Ends the block of code being monitored for errors

Commits a transaction

14 / 20

What does the COMMIT statement do in a transaction?

Ends the transaction without saving changes

Starts a new transaction

Reverts all changes made during the transaction

Saves all changes made during the transaction

15 / 20

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

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

To save the transaction

To start a new transaction

To commit the transaction automatically

16 / 20

What is a transaction in SQL Server?

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

A system procedure

A type of database

A user-defined function

17 / 20

Which of the following SQL Server features ensures that all parts of a transaction are completed successfully before committing?

Consistency

Durability

Isolation

Atomicity

18 / 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 state of the last Transact-SQL statement executed

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

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

19 / 20

What does the RAISERROR statement do in SQL Server?

Starts a new transaction

Rolls back a transaction

Commits a transaction

Generates an error message and initiates error processing

20 / 20

What is the purpose of the END CATCH statement?

To end a transaction

To rollback a transaction

To end the block of code-handling errors

To commit a transaction

Your score is

The average score is 0%

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!