« previous next »

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

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Transfer of lamda prophage during conjugation can trigger lysis Transfer of lamda prophage during conjugation can trigger lysis
What are examples of ideal forms? What are examples of ideal forms?
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 ...
How to Factor a Difference of Squares How to Factor a Difference of Squares
Locations and reference zones of trigger points that cause headaches. A. Upper trapezius. B. ... Locations and reference zones of trigger points that cause headaches. A. Upper trapezius. B. ...
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: Graded potentials - electrical characteristics and types

For a complete list of videos, visit our video library