This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: During the database redesign process, you discover that when an ORDER is deleted, its corresponding ... (Read 93 times)

ENagel

  • Hero Member
  • *****
  • Posts: 540
on: Jul 7, 2018
During the database redesign process, you discover that when an ORDER is deleted, its corresponding entries in the LINE_ITEM table are not deleted (but you would like them to be). In order to fix, this, you use what SQL syntax?
 
  A) ON UPDATE CASCADE
  B) ON DELETE CASCADE
  C) CASCADE CONSTRAINTS
  D) DEFAULT

Question 2

Which of the following is not a type of trigger supported by SQL Server?
 
  A) BEFORE
  B) INSTEAD OF
  C) CONCURRENT
  D) Both A and C are correct


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

thall411

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

B

Answer to Question 2

D


ENagel

  • Member
  • Posts: 540
Reply 2 on: Jul 7, 2018
Excellent

aruss1303

  • Member
  • Posts: 314
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Simplified diagram of the fractional distillation process Simplified diagram of the fractional distillation process
Upsetting the entire social order, the French Revolution removed the past as a sure guide to the ... Upsetting the entire social order, the French Revolution removed the past as a sure guide to the ...
The healing process of a bone. The healing process of a bone.
How to evaluate the second order determinant How to evaluate the second order determinant
Research Methods: A Process of Inquiry Research Methods: A Process of Inquiry
In order to encourage Canadians to avoid cross border shopping, Walmart Canada is striving to ... In order to encourage Canadians to avoid cross border shopping, Walmart Canada is striving to ...
Video: Resting membrane potential - electrical polarity and maintenance requirements

For a complete list of videos, visit our video library