Exam 70-761 topic 1 question 163 discussion

DRAG DROP -
You run the following Transact-SQL statement:

You need to create a stored procedure that meets the following requirements:
✑ Inserts data into the Employees table.
✑ Processes all data changes as a single unit of work.
✑ Sets the exception severity level to 16 and an error number of 60, 000 when any error occurs.
✑ If a Transact-SQL statement raises a runtime error, terminates and reverts the entire unit of work, and indicates the line number in the statement where the error occurred.
✑ Inserts the value New Employee for the Title column if no title is provided.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segment to the correct target. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Suggested Answer:
References:
https://stackoverflow.com/questions/180075/executing-a-stored-procedure-inside-begin-end-transaction