« previous next »

Author Question: Briefly describe three types of triggers. What will be an ideal ... (Read 43 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?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

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?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Types and characteristics of stem cells for culture Types and characteristics of stem cells for culture
Three Types of Lunar Eclipses Three Types of Lunar Eclipses
The Types of Stars and Their Sizes The Types of Stars and Their Sizes
Different types of bone fractures Different types of bone fractures
Basic Cloud Types Basic Cloud Types
Types of Volcanoes Types of Volcanoes
Video: Amniocentesis and CVS Animation

For a complete list of videos, visit our video library