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

Animal_Goddess

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

« previous next »
 

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Hemodialysis. The process of hemodialysis replaces the kidney function of blood filtration by forcin Hemodialysis. The process of hemodialysis replaces the kidney function of blood filtration by forcin
Palatine process Palatine process
A medical records department. (Paper records are becoming obsolete, replaced by electronic records.) A medical records department. (Paper records are becoming obsolete, replaced by electronic records.)
The lower respiratory tract and the process of gas exchange. The lower respiratory tract and the process of gas exchange.
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ... Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ...
Video: Cerebral Cortex Animation

For a complete list of videos, visit our video library