This topic contains a solution. Click here to go to the answer

Author Question: Which of the following code samples show a trigger that would intercept a DELETE before it happens? ... (Read 40 times)

genevieve1028

  • Hero Member
  • *****
  • Posts: 601
Which of the following code samples show a trigger that would intercept a DELETE before it happens?
 
  A) CREATE TRIGGER tr_RemoveCustomer ON Customer
  FOR DELETE
  B) CREATE TRIGGER tr_RemoveCustomer ON Customer
  AFTER DELETE
  C) CREATE TRIGGER tr_RemoveCustomer ON Customer
  INSTEAD OF DELETE
  D) None of the above

Question 2

Insert permission is the permission to add records to the database.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

annierak

  • Sr. Member
  • ****
  • Posts: 340
Answer to Question 1

C

Answer to Question 2

TRUE





 

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

For a complete list of videos, visit our video library