« previous next »

Author Question: What is the difference between a trigger and a routine? What will be an ideal ... (Read 25 times)

NClaborn

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
What is the difference between a trigger and a routine?
 
  What will be an ideal response?

Question 2

Which of the following is not one of the four security levels of incidents?
 
  A) False alarms
  B) Minor incidents
  C) Virus epidemics
  D) Disasters
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


mcabuhat

  • Sr. Member
  • ****
  • Posts: 344
Reply #1 on: Jul 7, 2018
Answer to Question 1

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.

Answer to Question 2

Answer: C


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

For some Americans, religion is an “easy-going, makes-little-difference” matter, as expressed in ... For some Americans, religion is an “easy-going, makes-little-difference” matter, as expressed in ...
The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ... The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ...
Using a scan tool to check for IAC counts or percentage as part of a diagnostic routine. Using a scan tool to check for IAC counts or percentage as part of a diagnostic routine.
Ischemic compression (i.e., direct pressure) to a trigger point in the trapezius muscle. Ischemic compression (i.e., direct pressure) to a trigger point in the trapezius muscle.
Difference spectra of mitochondria Difference spectra of mitochondria
There Is a Difference between Natural and Added Sugars There Is a Difference between Natural and Added Sugars
Video: Effect of blood chemistry - stimuli, hyperventilation response and hypoventilation response

For a complete list of videos, visit our video library