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.

View Answer

Answer: