« previous next »

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

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

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

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Flower part number is a characteristic difference between monocots and eudicots Flower part number is a characteristic difference between monocots and eudicots
Transfer of lamda prophage during conjugation can trigger lysis Transfer of lamda prophage during conjugation can trigger lysis
Difference between.... Difference between....
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 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 ...
Resting Membrane Potential: Voltage Difference Resting Membrane Potential: Voltage Difference
Video: Blood Test Basics

For a complete list of videos, visit our video library