« previous next »

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

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Types of isomers Types of isomers
he vertebrate stomach as an example of an organ composed of all four tissue types he vertebrate stomach as an example of an organ composed of all four tissue types
Parenteral medication administration. The angle of needle insertion for four different types of pare Parenteral medication administration. The angle of needle insertion for four different types of pare
Summary of T-Cell Types Summary of T-Cell Types
Six types of synovial joints. Six types of synovial joints.
Types of mutations Types of mutations
Video: Requirements for nervous signals

For a complete list of videos, visit our video library