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

codyclark · **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