What is the difference between a trigger and a routine?
What will be an ideal response?
A trigger, once written and compiled, sits silently on the database server waiting for an event to happen. It is usually tied to one table and some action, such as insert, update or delete. Conversely, a routine has to be called even though it resides on the database server. It may access one, many or no tables in order to produce the desired results.
You might also like to view...
The term used to describe the unique combination of activities that an organization implements to create a product solution to meet customer needs is ________
a. promotion b. marketing mix c. marketing research d. market segmentation
Investment revenue includes interest and dividends, and realized and unrealized gains and losses on investments
a. True b. False Indicate whether the statement is true or false