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 88 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

emsimon14

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

The clotting process (coagulation). The clotting process (coagulation).
Larynx, trachea, bronchi, and lungs with an expanded view showing the structures of an alveolus and Larynx, trachea, bronchi, and lungs with an expanded view showing the structures of an alveolus and
Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage. Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage.
Afterload is the pressure that the ventricles must overcome in order to open the aortic and pulmonic Afterload is the pressure that the ventricles must overcome in order to open the aortic and pulmonic
Deleted. Deleted.
Macrophage caught in the process of engulfing tuberculosis bacteria. Macrophage caught in the process of engulfing tuberculosis bacteria.
Video: Exercise and cardiac output

For a complete list of videos, visit our video library