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 43 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
YES! Correct, THANKS for helping me on my review

cam1229

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

« previous next »
 

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

An overview of the process of primary and secondary growth in a woody stem. An overview of the process of primary and secondary growth in a woody stem.
Major moons of Uranus in order of increasing distance (left to right), at their proper relative size Major moons of Uranus in order of increasing distance (left to right), at their proper relative size
Model of the Reading Process Model of the Reading Process
A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ... A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ...
Condyle process Condyle process
Facet of superior articular process Facet of superior articular process
Video: Interpreting a cladogram Animation

For a complete list of videos, visit our video library