« previous next »

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

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

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?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

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?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

For some Americans, religion is an “easy-going, makes-little-difference” matter, as expressed in ... For some Americans, religion is an “easy-going, makes-little-difference” matter, as expressed in ...
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.
What's the Difference Between England, Great Britain, and United Kingdom? What's the Difference Between England, Great Britain, and United Kingdom?
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
An electron is accelerated from rest through a potential difference. After acceleration the ... An electron is accelerated from rest through a potential difference. After acceleration the ...
Video: Non-specific disease resistance mechanisms & Skin's defense barriers

For a complete list of videos, visit our video library