« previous next »

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

Cyanide works by making the human body unable to use oxygen.

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Flower part number is a characteristic difference between monocots and eudicots Flower part number is a characteristic difference between monocots and eudicots
Difference between Asian (left) and African (right) elephant ears. Difference between Asian (left) and African (right) elephant ears.
A typical open-end wrench. Note the size difference on each end and that the head is angled 15 ... A typical open-end wrench. Note the size difference on each end and that the head is angled 15 ...
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) ...
Sensitivity study for facial difference Sensitivity study for facial difference
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Hemoglobin's affinity with oxygen - carbon dioxide, temperature and bisphosphoglycerate (BPG)

For a complete list of videos, visit our video library