Question 6 of-Sulhject: Databases Topic: Triggers and Events I Time Remaining: 5

Question

Question 6 of-Sulhject: Databases Topic: Triggers and Events I Time Remaining: 51 minutes 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 FOR EACH ROW DELETE FROM membersPasswords WHERE memberID -members.memberlD true false - if a member is deleted who didl not lhaye a password, the tigger will not be lired e true false- if a member changes their name, the trigger will be fired .trie.lalie . if a member deletes their password detrigger will be fired o true false- if all meabers with first aame Jum are deleted, this trigger may get fired many times Record Answer

Explanation / Answer

1) False. Trigger is on delete from members table so whenever there is delete on members table, trigger will always be fired and if password exists for that member the corresponding entry will be deleted otherwise no change in memberspasswords table.

2) False. Changing names will fire update query on table members and this trigger is on delete query on members.

3) False. Again the query is on delete on members and not on delete on memberspasswords.

4) True. If there exists multiple records with firstname as Jim then all such records will be deleted from members table and all corresponding passwords must be deleted from memberspasswords table.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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