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 89 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
:D TYSM

epscape

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

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
Color mixtures of refracted light—additive process. Color mixtures of refracted light—additive process.
Lean 6 Sigma - LHM Process Flow Diagram Lean 6 Sigma - LHM Process Flow Diagram
Six-Step Process for Goal-Oriented Planning Six-Step Process for Goal-Oriented Planning
Research Methods: A Process of Inquiry Research Methods: A Process of Inquiry
In a metallurgical process the mineral pyrite, FeS2, is roasted in air: FeS2 + O2 Fe2O3 + ... In a metallurgical process the mineral pyrite, FeS2, is roasted in air: FeS2 + O2 Fe2O3 + ...
Video: Miller's reaction chamber experiment Animation

For a complete list of videos, visit our video library