Question

Point out the correct statement.

(a) While executing some DML Statement like INSERT, DELETE, UPDATE we can handle the error for checking proper output

(b) If transaction fails, then we need to commit – This can be done by error handling

(c) If transaction succeeds, then we need to rollback – This can be done by error handling

(d) None of the mentioned

I got this question in an online interview.

I'd like to ask this question from Error Handling in division Developing with SQL Server of SQL Server

Answer 1

The correct choice is (a) While executing some DML Statement like INSERT, DELETE, UPDATE we can handle the error for checking proper output

To elaborate: SQL Server also has an exception model to handle exceptions and errors that occurs in T-SQL statements.