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 you try to change a DEPARTMENT name ... (Read 91 times)

codyclark

  • Hero Member
  • *****
  • Posts: 538
on: Jul 7, 2018
During the database redesign process, you discover that when you try to change a DEPARTMENT name (the department's primary key), the change is disallowed by the DBMS due to your design of the EMPLOYEE table (which has a foreign key referencing
 
  DEPARTMENT) You want the change to be allowed. In order to fix this, you use what SQL syntax?A) ON UPDATE CASCADE
  B) ON DELETE CASCADE
  C) ADD CONSTRAINT
  D) FOREIGN KEY

Question 2

A view may not be assigned to a(n) ________.
 
  A) BEFORE trigger
  B) INSTEAD OF trigger
  C) CONCURRENT trigger
  D) AFTER trigger


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

k2629

  • Sr. Member
  • ****
  • Posts: 357
Reply #1 on: Jul 7, 2018
Answer to Question 1

A

Answer to Question 2

D


codyclark

  • Member
  • Posts: 538
Reply 2 on: Jul 7, 2018
Excellent

jomama

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

« previous next »
 

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Communication as active process Communication as active process
Small nuclear RNAs (snRNA), 100-200 bp in length, form part of the splicing mechanisms to process mR Small nuclear RNAs (snRNA), 100-200 bp in length, form part of the splicing mechanisms to process mR
Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco
Change in Emotional States During Adolescence Average emotional state becomes teadilyi more negativ Change in Emotional States During Adolescence Average emotional state becomes teadilyi more negativ
Change in plasma metabolomics following glucose igestion Change in plasma metabolomics following glucose igestion
Ancient Climate Change Ancient Climate Change
Video: Properties of macromolecules (Explained with No Audio)

For a complete list of videos, visit our video library