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 40 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
Excellent

amandanbreshears

  • Member
  • Posts: 320
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Coronoid process Coronoid process
The Three Stages of the Birth Process The Three Stages of the Birth Process
On March 25, 1911, as scores of young factory girls leaped to their deaths from the eighth, ninth, a On March 25, 1911, as scores of young factory girls leaped to their deaths from the eighth, ninth, a
If drug elimination mechanisms become saturated, a drug may exhibit zero-order elimination. If drug elimination mechanisms become saturated, a drug may exhibit zero-order elimination.
The communication process The communication process
How Does Earth Work? Physical Geology and the Process of Science, 2nd Edition How Does Earth Work? Physical Geology and the Process of Science, 2nd Edition
Video: Autonomic Nervous System Animation

For a complete list of videos, visit our video library