Microsoft
70-433 · Question #102
70-433 Question #102: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #102. The question stem and answer options stay visible for context.
Question
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 Transact-SQL 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?
Options
- A--The product will be deleted from the Products table.
- B--The product will be deleted from the Products table.
- C--The product will not be deleted from the Products table.
- D--The product will not be deleted from the Products table.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.