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 BEGIN CATCH statement?

To rollback a transaction

To commit a transaction

To start a new transaction

To start a block of code to handle errors

2 / 20

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

REPEATABLE READ

READ UNCOMMITTED

READ COMMITTED

SERIALIZABLE

3 / 20

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

REVERT

CANCEL

UNDO

ROLLBACK

4 / 20

Which command is used to set the transaction isolation level?

SET TRANSACTION LEVEL

SET TRANSACTION ISOLATION LEVEL

SET ISOLATION TRANSACTION

SET ISOLATION LEVEL

5 / 20

Which function returns the state number of an error?

ERROR_CONDITION()

ERROR_STATE()

ERROR_STATUS()

ERROR_PHASE()

6 / 20

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

REPEATABLE READ

READ COMMITTED

SERIALIZABLE

READ UNCOMMITTED

7 / 20

What is the purpose of the @@ERROR function?

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

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

8 / 20

What does the RAISERROR statement do in SQL Server?

Commits a transaction

Generates an error message and initiates error processing

Rolls back a transaction

Starts a new transaction

9 / 20

Which isolation level allows dirty reads?

READ UNCOMMITTED

SERIALIZABLE

REPEATABLE READ

READ COMMITTED

10 / 20

What function returns the line number where an error occurred?

ERROR_POINT()

ERROR_LOCATION()

ERROR_POSITION()

ERROR_LINE()

11 / 20

What is the purpose of the ROLLBACK TRANSACTION statement?

To undo all changes made during the transaction

To save all changes made during the transaction

To start a new transaction

To end the transaction without saving changes

12 / 20

Which command is used to check the current transaction status?

@@TRANCOUNT

@@TRANSACTION

@@TRANSSTATE

@@TRANSTATUS

13 / 20

What is a transaction in SQL Server?

A system procedure

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

A user-defined function

A type of database

14 / 20

What does the COMMIT statement do in a transaction?

Saves all changes made during the transaction

Starts a new transaction

Reverts all changes made during the transaction

Ends the transaction without saving changes

15 / 20

Which function returns the error number in a CATCH block?

ERROR_NUMBER()

ERROR_ID()

ERROR_CODE()

ERROR_VALUE()

16 / 20

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

INITIATE TRANSACTION

BEGIN TRANSACTION

OPEN TRANSACTION

START TRANSACTION

17 / 20

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

ERROR_SEVERITY()

ERROR_GRADE()

ERROR_INTENSITY()

ERROR_LEVEL()

18 / 20

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

To start a new transaction

To commit the transaction automatically

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

To save the transaction

19 / 20

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

Starts a new transaction

Rolls back a transaction

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

Commits a transaction

20 / 20

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

Durability

Atomicity

Consistency

Isolation

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!