« previous next »

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

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

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?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Transfer of lamda prophage during conjugation can trigger lysis Transfer of lamda prophage during conjugation can trigger lysis
Brachial Plexus drawing plus the difference in the forearm Brachial Plexus drawing plus the difference in the forearm
The difference between a human and an ape. The difference between a human and an ape.
The slight (5 microsecond) difference in the firing of the companion cylinders is enough time to ... The slight (5 microsecond) difference in the firing of the companion cylinders is enough time to ...
Difference spectra of mitochondria Difference spectra of mitochondria
Sheridan Motors is a car dealership that would like to investigate if there is a difference in ... Sheridan Motors is a car dealership that would like to investigate if there is a difference in ...
Video: What is Cholesterols? Introduction to Lipoproteins

For a complete list of videos, visit our video library