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...
Under the revised version of the OECD's Principles of Corporate Governance, institutional investors are specifically urged to disclose their corporate governance policies so the public can better understand how they are using their voting rights.
Answer the following statement true (T) or false (F)
According to the text, which of the following types of questions does not apply to survey research?
A) questions regarding behavior B) questions regarding attitudes C) questions regarding lifestyle characteristics D) questions regarding observational research E) questions regarding motivations
A company with $50,000 in current assets, $25,000 in quick assets, and $30,000 in current liabilities makes a payment of a $1,500 current debt. As a result of this transaction, the current ratio and quick ratio will
a. both decrease. b. increase and decrease, respectively. c. both increase. d. remain the same and decrease, respectively.
A ________ is a group of states that have reduced or eliminated tariffs among themselves and have also established a common external tariff
A. customs union B. free trade area C. Harmonized System D. Wassenaar Arrangement