Page 1 of 1
6. When defining the Foreign Key constraint (see the partial code given below), why we only specify "ON DELETE" and/or "
Posted: Fri Jul 01, 2022 5:52 am
by answerhappygod
- 6 When Defining The Foreign Key Constraint See The Partial Code Given Below Why We Only Specify On Delete And Or 1 (108.96 KiB) Viewed 47 times
6. When defining the Foreign Key constraint (see the partial code given below), why we only specify "ON DELETE" and/or "ON UPDATE" but do not specify "ON INSERT"? Explain. [1 mark] CREATE TABLE EMPLOYEE ( FOREIGN KEY(Dno) REFERENCES DEPARTMENT(Dnumber) ON DELETE SET DEFAULT ON UPDATE CASCADE) ;