If a DBMS enforces an UPDATE RESTRICT 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
A
You might also like to view...
The aggregate of all elements, sharing some common set of characteristics, which comprise the universe for the purpose of the marketing research problem, is called the ________
A) sample B) inference C) hypothesis D) population E) element aggregate
Which of the following is an example of an estimable probable contingency?
A) FICA Taxes Payable B) Income Taxes Payable C) Warranty Payable D) Accounts Payable
The __________ describes the organization's reason for existence.
Fill in the blank(s) with the appropriate word(s).
The capital accounts of Harrison and Marti have balances of $180,000 and $130,000, respectively, on January 1, 2010, the beginning of the current fiscal year. On April 10, Harrison invested an additional $20,000. During the year, Harrison and Marti withdrew $96,000 and $78,000, respectively, and net income for the year was $248,000. The articles of partnership make no reference to the division of
net income. Based on this information, the statement of partners' equity for the 2010 for the partnership would show what amount in as total capital for the partnership on December 31, 2010? A) $228,000 B) $176,000 C) $404,000 D) $752,000