DRAG DROP
You have two tables named UserLogin and Employee respectively.
You need to create a Transact-SQL script that meets the following requirements:
The script must update the value of the IsDeleted column for the UserLogin table to1if the value of the Id
column for the UserLogin table is equal to1.
The script must update the value of the IsDeleted column of the Employee table to1if the value ofthe Id
column is equal to1for the Employee table when an update to the UserLogin table throws an error.
The error message “No tables updated!” must be produced when an update to the Employee table throws
an error.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the
correct order.
Select and Place:
Answer: 
Explanation:
A TRY block must be immediately followed by an associated CATCH block. Including any other statements
between the END TRY and BEGIN CATCH statements generates a syntax error.
https://msdn.microsoft.com/en-us/library/ms175976.aspx
Answer is incoorect
Correct answer is:
BEGIN TRY
UPDATE dbo.UserLogin
SET IsDeleted = 1
WHERE Id = 1
END TRY
BEGIN CATCH
BEGIN TRY
UPDATE dbo.Employee
SET IsDeletedFlag = 1
WHERE Id = 1
END TRY
BEGIN CATCH
RAISERROR (‘No tables updated!’,16,1)
END CATCH
END CATCH
2 times END CATCH??
BEGIN TRY
UPDATE dbo.Employee
SET IsDeletedFlag = 1
WHERE Id = 1
END TRY
there is no “END TRY” line in the option. other than this, I agree