You have tables named Products and OrderDetails. The Products table has a foreign key relationship
with the OrderDetails table on the ProductID column. You have the following TransactSQL
batch:
BEGIN TRY
BEGIN TRANSACTION
DELETE FROM Products WHERE ProductID = 5;
BEGIN TRANSACTION
INSERT INTO OrderDetails
( OrderID, ProductID, Quantity )
VALUES
( 1234, 5, 12 );
COMMIT TRANSACTION
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
PRINT ERROR_MESSAGE();
END CATCH
You need to analyze the result of executing this batch. What should be the expected outcome?
A.
1. The product will be deleted from the Products table.
2. The order details will be inserted into the OrderDetails table.
B.
1. The product will be deleted from the Products table.
2. The order details will not be inserted into the OrderDetails table.
C.
1. The product will not be deleted from the Products table.
2. The order details will be inserted into the OrderDetails table.
D.
1. The product will not be deleted from the Products table.
2. The order details will not be inserted into the OrderDetails table.