MS SQL Server - 34 - TRY CATCH THROW MCQ

34 – TRY CATCH THROW MCQ

Best of luck!

1 / 23

1. In SQL Server, what is the primary purpose of the TRY…CATCH construct?

To declare local variables

To handle exceptions and errors in a structured manner

To stop the execution of a query

To create custom error messages

2 / 23

2. Which SQL statement is used to begin a TRY block in SQL Server?

TRY BEGIN

TRY

BEGIN TRY

START TRY

3 / 23

3. What is the primary purpose of the CATCH block in SQL Server’s TRY…CATCH construct?

To retrieve data from tables

To create custom error messages

To handle exceptions and errors that occur during execution

To execute a block of statements if no exceptions occur

4 / 23

4. In SQL Server, what is the primary purpose of the THROW statement?

To raise an exception with a specified error number and message

To create custom error messages

To exit the CATCH block

To retrieve data from tables

5 / 23

5. Which keyword is used to re-raise an exception within a CATCH block in SQL Server?

RERAISE

THROW

SIGNAL

RE-RAISE

6 / 23

6. In SQL Server, what is the purpose of the @@ERROR function?

To retrieve data from tables

To create custom error messages

To retrieve the error code for the most recent error that occurred

To check for errors in the CATCH block

7 / 23

7. In SQL Server, which keyword is used to specify a custom error message when using the THROW statement?

ERROR_MESSAGE

STRING

CUSTOM

MESSAGE

8 / 23

8. What is the primary use of the TRY…CATCH construct in SQL Server’s error handling?

To handle and manage errors in a controlled manner

To create custom error messages

To allow errors to propagate without intervention

To suppress all errors and exceptions

9 / 23

9. In SQL Server, when does control transfer from the TRY block to the CATCH block?

After every statement in the TRY block

After an error occurs in the TRY block

Only when explicitly requested using the THROW statement

When the TRY block is executed

10 / 23

10. In SQL Server, what happens if no exception occurs in the TRY block and there’s no explicit THROW statement?

The query stops executing.

An error is generated.

The control remains in the TRY block.

The control automatically transfers to the CATCH block.

11 / 23

11. In SQL Server, what is the primary purpose of the THROW statement with no arguments?

To raise the last caught exception with the same error number and message

To create custom error messages

To exit the CATCH block

To retrieve data from tables

12 / 23

12. What is the primary use of the TRY_CONVERT function in SQL Server’s error handling?

To retrieve data from tables

To exit the CATCH block

To explicitly convert data types and handle conversion errors

To create custom error messages

13 / 23

13. In SQL Server, which keyword is used to specify the error number when using the THROW statement to raise an exception?

RAISE_ERROR

EXCEPTION_NUMBER

ERROR

ERROR_NUMBER

14 / 23

14. What is the purpose of the SET XACT_ABORT ON statement in SQL Server’s error handling?

To create custom error messages

To enable automatic transaction rollback on error

To exit the CATCH block

To retrieve data from tables

15 / 23

15. In SQL Server, what is the primary use of the THROW statement with a custom error severity level?

To specify a custom error severity level for the raised exception

To exit the CATCH block

To retrieve data from tables

To create custom error messages

16 / 23

16. What happens if an unhandled exception occurs in a TRY…CATCH block in SQL Server?

The exception is ignored.

The script stops executing.

The server crashes.

The CATCH block is executed.

17 / 23

17. In SQL Server, what is the purpose of the THROW statement with a custom state value?

To retrieve data from tables

To create custom error messages

To specify a custom state value for the raised exception

To exit the CATCH block

18 / 23

18. What is the primary purpose of the ERROR_MESSAGE() function in SQL Server’s error handling?

To create custom error messages

To retrieve data from tables

To retrieve the error message text for the last error that occurred

To exit the CATCH block

19 / 23

19. In SQL Server, which keyword is used to begin a TRY…CATCH block with multiple catch blocks?

BEGIN

MULTI-CATCH

CATCH

TRY

20 / 23

20. In SQL Server, what is the purpose of the TRY…CATCH construct when using nested transactions?

To create custom error messages

To exit the CATCH block

To retrieve data from tables

To handle exceptions and errors within nested transactions

21 / 23

21. What is the primary purpose of the ERROR_STATE() function in SQL Server’s error handling?

To create custom error messages

To retrieve data from tables

To retrieve the error state for the last error that occurred

To exit the CATCH block

22 / 23

22. In SQL Server, what is the primary purpose of the TRY…CATCH construct when dealing with batch-level errors?

To handle exceptions and errors at the batch level

To create custom error messages

To exit the CATCH block

To retrieve data from tables

23 / 23

23. What is the primary purpose of the THROW statement with the option THROW 0 in SQL Server’s error handling?

To re-raise the original exception without changing its state

To retrieve data from tables

To exit the CATCH block

To create custom error messages

Your score is

MS SQL Server – 34 – TRY CATCH THROW MCQ