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 35 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
:D TYSM

meganmoser117

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

« previous next »
 

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

The process of clot formation. The process of clot formation.
Palatine process Palatine process
Ogburn's Processes of Social Change Ogburn's Processes of Social Change
Ancient Climate Change Ancient Climate Change
Change is hard at first messy in the middle and gorgeous at the end Change is hard at first messy in the middle and gorgeous at the end
The following information relates to the Cutting Department of Kittina Corporation for the ... The following information relates to the Cutting Department of Kittina Corporation for the ...
Video: Interview with Person who has Panic Attacks

For a complete list of videos, visit our video library