q16

Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course no description, created by, created-date modified by modified date) VALUES (COLES no_seq. nextval database developent ISER, SYNDATE) COMMIT DEMS OUTPUT.PUT LINE 'One course has been added IND Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null. 1. Explain why the script does not execute successfully (2 points) 2. Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception. (2 points) E the RSS E