« previous next »

Author Question: Briefly describe three types of triggers. What will be an ideal ... (Read 86 times)

Beheh

  • Hero Member
  • *****
  • Posts: 520
on: Jul 7, 2018
Briefly describe three types of triggers.
 
  What will be an ideal response?

Question 2

Transactions should be written to the log before they are applied to the database itself.
 
  Indicate whether the statement is true or false


epscape

  • Sr. Member
  • ****
  • Posts: 335
Reply #1 on: Jul 7, 2018
Answer to Question 1

Common types of triggers include BEFORE triggers, AFTER triggers, and INSTEAD OF triggers. BEFORE triggers are modules of procedural logic that the DBMS automatically invokes before inserting, updating, or deleting data. An AFTER trigger is a module of procedural logic that the DBMS automatically invokes after inserting, updating, or deleting data. INSTEAD OF triggers are modules of procedural logic that the DBMS automatically invokes in place of inserting, updating, or deleting data.

Answer to Question 2

TRUE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Brain types Brain types
Types and locations of epithelial tissues. Types and locations of epithelial tissues.
Blood types and results of donor and recipient combinations. Blood types and results of donor and recipient combinations.
ABO blood types pedigree ABO blood types pedigree
Types of Mutations in the HBB Gene That Cause p-Thalassemia Types of Mutations in the HBB Gene That Cause p-Thalassemia
Three Types of Neurons Three Types of Neurons
Video: The Lac Operon in E. Coli

For a complete list of videos, visit our video library