Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP
You are a Microsoft SQL Server client tools to develop a Microsoft Azure SQL Database database that supports an e-learning application. The database consists of a Course table, a Subject table, and a CourseSubject table as shown in the exhibit. (Click the Exhibit button.)

You need to write a trigger that meets the following requirements:
Subjects are not physically deleted, but are marked as deleted.
When a subject is deleted, the courses that offer that subject are marked as discontinued.
Which four 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:

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.