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 function of an END TRY statement?

Ends a transaction

Ends the block of code being monitored for errors

Commits a transaction

Rolls back a transaction

2 / 20

What function returns the error message in a CATCH block?

ERROR_INFO()

ERROR_MESSAGE()

ERROR_TEXT()

ERROR_DETAIL()

3 / 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 severity 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

4 / 20

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

REPEATABLE READ

SERIALIZABLE

READ UNCOMMITTED

READ COMMITTED

5 / 20

Which isolation level provides the highest level of data consistency?

READ UNCOMMITTED

READ COMMITTED

REPEATABLE READ

SERIALIZABLE

6 / 20

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

ERROR_FUNCTION()

ERROR_PROCEDURE()

ERROR_ROUTINE()

ERROR_TRIGGER()

7 / 20

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

ERROR_SEVERITY()

ERROR_INTENSITY()

ERROR_LEVEL()

ERROR_GRADE()

8 / 20

What is a transaction in SQL Server?

A system procedure

A type of database

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

A user-defined function

9 / 20

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

Consistency

Durability

Isolation

Atomicity

10 / 20

What does the RAISERROR statement do in SQL Server?

Starts a new transaction

Commits a transaction

Rolls back a transaction

Generates an error message and initiates error processing

11 / 20

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

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

To start a new transaction

To commit a part of the transaction

To end the transaction

12 / 20

What function returns the line number where an error occurred?

ERROR_POINT()

ERROR_LINE()

ERROR_POSITION()

ERROR_LOCATION()

13 / 20

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

REPEATABLE READ

READ COMMITTED

READ UNCOMMITTED

SERIALIZABLE

14 / 20

Which function returns the state number of an error?

ERROR_CONDITION()

ERROR_PHASE()

ERROR_STATUS()

ERROR_STATE()

15 / 20

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

REVERT

UNDO

CANCEL

ROLLBACK

16 / 20

Which isolation level allows dirty reads?

REPEATABLE READ

SERIALIZABLE

READ UNCOMMITTED

READ COMMITTED

17 / 20

What is the purpose of the ROLLBACK TRANSACTION statement?

To end the transaction without saving changes

To save all changes made during the transaction

To undo all changes made during the transaction

To start a new transaction

18 / 20

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

INITIATE TRANSACTION

BEGIN TRANSACTION

START TRANSACTION

OPEN TRANSACTION

19 / 20

Which command is used to check the current transaction status?

@@TRANSACTION

@@TRANSTATUS

@@TRANSSTATE

@@TRANCOUNT

20 / 20

What is the purpose of the COMMIT TRANSACTION statement?

To save all changes made during the transaction

To end the transaction without saving changes

To start a new transaction

To undo all changes made during the transaction

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!