Question: give me the answer If we insert this function into the database, what would be the most appropriate way to set up the trigger, if
give me the answer
If we insert this function into the database, what would be the most appropriate way to set up the trigger, if we want all of the standard constraint checks to be carried out before checking this condition. create trigger checkAssert before insert or update on S (a) O for each row execute procedure checkXlarger(); create trigger checkAssert after insert or update on S (b) O for each row execute procedure checkXlarger(); create trigger checkAssertl before insert or update on S for each row execute procedure checkXlarger(); (c)O create trigger checkAssert2 before insert or update on T for each row execute procedure checkXlarger(); create trigger checkAssert1 after insert or update on S for each row execute procedure checkXlarger(); (d) O create trigger checkAssert2 after insert or update on T for each row execute procedure checkXlarger(); No trigger is needed; this whole question is a bluff. This checking could be done more simply with standard database (e)O constraintsStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
