subject

If a DBMS enforces an UPDATE CASCADE option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after a user tries to change the AgentID value in the last record to A5?

a) Value A4 appears once in column AgentID in AGENT, and value A4 appears once in column ClientAgent in table CLIENT
b) Value A5 appears once in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT
c) Value A5 appears once in column AgentID in AGENT, and value A5 does not appear in column ClientAgent in table CLIENT
d) Value A5 does not appear in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 06:30
Who can provide you with a new password when you have forgotten your old one? your provide you with a new password in case you forget your old one.
Answers: 3
question
Computers and Technology, 23.06.2019 06:40
What are the three uses of a screw?
Answers: 2
question
Computers and Technology, 23.06.2019 18:30
How often does colleges update the cost of attendance on their website? . a)every two years b) every four years c) every year d) every semester
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that
Answers: 2
You know the right answer?
If a DBMS enforces an UPDATE CASCADE option on the referential integrity constraint between CLIENT a...
Questions
question
Mathematics, 26.06.2019 01:10