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 95 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
Thanks for the timely response, appreciate it

Animal_Goddess

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Russia has the highest death rate from cardiovascular disease followed by the Ukraine, Romania, Hungary, and Poland.

Birth Order and Intelligence Birth Order and Intelligence
The process of learning to read involves physical and socioemotional development, changes in the ... The process of learning to read involves physical and socioemotional development, changes in the ...
(a) The phagocytic process, beginning in the upper left with bacterial attachment and phagocytic ... (a) The phagocytic process, beginning in the upper left with bacterial attachment and phagocytic ...
Three Phases of the Tissue/Wound Repair Process. Three Phases of the Tissue/Wound Repair Process.
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.
How to use Cramer's rule to solve a second-order determinant (Question 1) How to use Cramer's rule to solve a second-order determinant (Question 1)
Video: Chemical Buffers - protein buffer, phosphate buffer system and bicarbonate buffer system

For a complete list of videos, visit our video library