Assume 2 tables where memberspassword.memberid if foreign key to members.memberl

Question

Assume 2 tables where memberspassword.memberid if foreign key to members.memberlD members (memberlD, first, last,dob memberspasswords (memberlD, password And the trigger below is in effect CREATE TRIGGER deletePasswordOfDeletedMembers BEFORE DELETE ON members OR EACH ROW DELETE FROM membersPasswords WHERE memberlD-members.memberlD true false - if a member is deleted who did not have a password, the trigger will not be fired true false-passwords in the memberspassword table can only be deleted by this trigger true false - if a member deletes their password, the trigger will be fired true·false. if this trigger was changed to an AFTER trigger, it would fail

Explanation / Answer

The above trigger basically will come into action only once the members are not deleted.If instead of BEFORE,AFTER was used then trigger would have worked after the persons id is removed.The password would have also been then deleted.

1)false

2)true

3)false

4)false

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.