Which of the following code samples show a trigger that would intercept a DELETE before it happens?
A) CREATE TRIGGER tr_RemoveCustomer ON Customer
FOR DELETE
B) CREATE TRIGGER tr_RemoveCustomer ON Customer
AFTER DELETE
C) CREATE TRIGGER tr_RemoveCustomer ON Customer
INSTEAD OF DELETE
D) None of the above
C
You might also like to view...
Rewards, value-added benefits, and customer recognition are three complementary elements in _____
a. relationship retailing b. customer service c. a service-based program d. a customer loyalty program
Answer the following statement(s) true (T) or false (F)
1. Organizations that have provided sensitivity training and workshops to their employees have noticed a decreased familiarity and increased bias against members of out-groups. 2. Surveys of diversity initiatives in selected multinational corporations indicate that these companies are planning, implementing, and evaluating a large number and variety of diversity initiatives in the United States only. 3. The cultural audit is usually performed by inside organizational experts who obtain data from surveys and focus groups. 4. The most common approach to diversity within the work organization is providing sensitivity training and workshops to employees. 5. Career development and planning diversity activities include establishing career development and planning initiatives for women and men of every represented group in the organization.
The Fed is an active participant in money markets mainly because of its responsibility to
A) lower borrowing costs to encourage capital investment. B) control the money supply. C) increase the interest income of retirees holding money market instruments. D) assist the Securities and Exchange Commission in regulating the behavior of other money market participants.
Pail, Inc. holds 100 percent of the common stock of Shovel Company, an investment acquired for $680,000. Immediately following the combination, Pail's net assets have a book value of $1,150,000 and a fair value of $1,390,000. The book value and the fair value of Shovel's net assets on the date of combination are $400,000 and $550,000, respectively. Immediately following the combination, a consolidated balance sheet is prepared.Based on the information given above, goodwill will be reported in the consolidated balance sheet in the amount of:
A. $270,000. B. $240,000. C. $130,000. D. $150,000.