« previous next »

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

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

The difference between AZT-sensitive versus AZT-resistant reverse transcriptases The difference between AZT-sensitive versus AZT-resistant reverse transcriptases
Positron emission tomography (PET) image showing the difference in the metabolic activity of the bra Positron emission tomography (PET) image showing the difference in the metabolic activity of the bra
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Difference between Functional and Cross-Functional team Difference between Functional and Cross-Functional team
Direct thumb pressure to a trigger point. Direct thumb pressure to a trigger point.
Difference Between a Sidereal Month and a Synodic Month Difference Between a Sidereal Month and a Synodic Month
Video: Structures that affect circulation - arterioles and vasomotor responses and venous return

For a complete list of videos, visit our video library