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 96 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
Wow, this really help

apple

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

« previous next »
 

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Six-Step Process for Goal-Oriented Planning Six-Step Process for Goal-Oriented Planning
How to evaluate third-order determinants by Minors Method (Question 2) How to evaluate third-order determinants by Minors Method (Question 2)
The General Process of Sensation The General Process of Sensation
The Bergeron Process The Bergeron Process
Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ... Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ...
Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ... Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ...
Video: Interview with Person who has Panic Attacks

For a complete list of videos, visit our video library