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

connor417

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

A hypothetical scenario illustrating the process of chemical selection A hypothetical scenario illustrating the process of chemical selection
Rinne test: A. Place the base of the tuning fork on the mastoid process. B. Place tuning fork in fro Rinne test: A. Place the base of the tuning fork on the mastoid process. B. Place tuning fork in fro
The five overlapping phases of the nursing process. Each phase depends on the accuracy of the other The five overlapping phases of the nursing process. Each phase depends on the accuracy of the other
The paleoanthropologist must understand these deformations in order to figure out which strata a fos The paleoanthropologist must understand these deformations in order to figure out which strata a fos
How to use implicit differentiation with higher order derivatives How to use implicit differentiation with higher order derivatives
Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage. Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage.
Video: Gastrulation: cross section of the frog

For a complete list of videos, visit our video library