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

ASDFGJLO

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

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?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

The process of plant tissue culture. The process of plant tissue culture.
Despite the globe’s vast social change, people all over the world continue to make race a ... Despite the globe’s vast social change, people all over the world continue to make race a ...
Upstream Process - Inoculum Preparation & Expansion Upstream Process - Inoculum Preparation & Expansion
The change in the net of an irradiance, in Wm-2, at the tropopause The change in the net of an irradiance, in Wm-2, at the tropopause
Capital-Biased Technological Change Capital-Biased Technological Change
The process of pharmacokinetics The process of pharmacokinetics
Video: Replication of DNA and Chromosomes/ How do cells replicate their DNA? (Animation) no Audio

For a complete list of videos, visit our video library