If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after auser 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
C
You might also like to view...
Before she began interviewing candidates for a sales position, Sonja prepared a written set of questions based on the job description and planned to ask each of the candidates the same questions in order to better compare their answers. Based on this information, it appears that Sonja was planning to conduct a(n) _____.
Fill in the blank(s) with the appropriate word(s).
________ is the practice of examining patterns and trends in historical stock prices
A) Technical analysis B) Fundamental analysis C) Event studying D) Insider trading