« previous next »

Author Question: What is the difference between a trigger and a routine? What will be an ideal ... (Read 37 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?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Difference between Asian (left) and African (right) elephant ears. Difference between Asian (left) and African (right) elephant ears.
what can trigger an asthmatic episode what can trigger an asthmatic episode
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.
Direct thumb pressure to a trigger point. Direct thumb pressure to a trigger point.
Difference spectra of mitochondria Difference spectra of mitochondria
Resting Membrane Potential: Voltage Difference Resting Membrane Potential: Voltage Difference
Video: Normal and abnormal blood pH

For a complete list of videos, visit our video library