nerdexam
Microsoft

70-433 · Question #103

You are using TRY...CATCH error handling. You need to raise an error that will pass control to the CATCH block. Which severity level should you use?

The correct answer is D. 16. A TRY...CATCH construct catches all execution errors that have a severity higher than 10 that do not close the database connection. Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered, the client connection is terminated after…

Implement Programming Objects

Question

You are using TRY...CATCH error handling. You need to raise an error that will pass control to the CATCH block. Which severity level should you use?

Options

  • A0
  • B9
  • C10
  • D16

How the community answered

(47 responses)
  • A
    6% (3)
  • B
    13% (6)
  • C
    2% (1)
  • D
    79% (37)

Explanation

A TRY...CATCH construct catches all execution errors that have a severity higher than 10 that do not close the database connection. Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered, the client connection is terminated after receiving the message, and the error is logged in the error and application logs. Severity levels less than 0 are interpreted as 0. Severity levels greater than 25 are interpreted as

Topics

#TRY CATCH#RAISERROR severity#error handling#CATCH block

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice