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

sailorcrescent

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

« previous next »
 

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

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?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

A speculum used to hold the vagina open in order to visualize the cervix. A speculum used to hold the vagina open in order to visualize the cervix.
For this bimolecular reaction, the rate constant k is second order For this bimolecular reaction, the rate constant k is second order
Ovulation Process The two ovaries alternate ovulation in each monthly cycle. Ovulation Process The two ovaries alternate ovulation in each monthly cycle.
The process of filtration in the kidneys, where smaller solutes, such as the electrolytes sodium and ... The process of filtration in the kidneys, where smaller solutes, such as the electrolytes sodium and ...
The healing process of a bone. The healing process of a bone.
Six-Step Process for Goal-Oriented Planning Six-Step Process for Goal-Oriented Planning
Video: Dendrite Animation

For a complete list of videos, visit our video library