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...
It is unethical to draw conclusions if data analysis did not reveal anything new or significant
Indicate whether the statement is true or false
Which of the following is an industrial product categorized under materials and parts?
A) factory B) cement C) generator D) drill presses E) coal
State and local governments are prohibited from complying with the overtime provisions of the Fair Labor Standards Act by giving employees compensatory time in lieu of overtime pay
a. True b. False Indicate whether the statement is true or false
It is presumptively negligent for anyone to drive within one hour after drinking more than two liquid ounces of alcohol in any beverage
Indicate whether the statement is true or false