CREATE TRIGGER Products_Delete ON Products FOR DELETE AS IF (SELECT COUNT(*) FROM [Order Details] OD WHERE OD.ProductID = (SELECT ProductID FROM Deleted)) 0 BEGIN PRINT 'Violate Foreign key reference. Rollback!!!' ROLLBACK TRAN END
What is the effect of this trigger?

Question

CREATE TRIGGER Products_Delete ON Products FOR DELETE AS IF (SELECT COUNT(*) FROM [Order Details] OD      WHERE OD.ProductID = (SELECT ProductID FROM Deleted)) > 0 BEGIN  PRINT 'Violate Foreign key reference. Rollback!!!'  ROLLBACK TRAN END 
 What is the effect of this trigger?

Answer

d.  Deletes all matching rows in Order Details

Answer

b.  Ignores constraint enforcement

Answer

a.  Prevents deletion if product exists in Order Details

Answer

c.  Allows deletion of products even if used in orders

Crowdly

CREATE TRIGGER Products_Delete ON Products FOR DELETE AS IF (SELECT COUNT(*) FR...

Want instant access to all verified answers on moodle.usth.edu.vn?