This topic contains a solution. Click here to go to the answer

Author Question: During the database redesign process, you discover that when you try to change a DEPARTMENT name ... (Read 100 times)

codyclark

  • Hero Member
  • *****
  • Posts: 538
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
Answer to Question 1

A

Answer to Question 2

D




codyclark

  • Member
  • Posts: 538
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)


jamesnevil303

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

 

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

For a complete list of videos, visit our video library