Question: QUESTION 6 points Consider the following PL/SQL script SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, moditied_dato) VALUES (course_no_seq.nextval. 'database development'.

 QUESTION 6 points Consider the following PL/SQL script SET SERVEROUTPUT ON

QUESTION 6 points Consider the following PL/SQL script SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, moditied_dato) VALUES (course_no_seq.nextval. 'database development'. USER, SYSDATE): COMMIT DEMS_OUTPUT.PUT_LINE Cone course has been added ENDI Assumptions: All the COURSE table fields have check constraints defined on the indicating that none can be rull 1. Explain why the seript does not execute successfully. (3 marks) 2. Add a user-defined exception to the seript, so that the error generated by the INSERT statement is handled. Assign the code 2290 this exception. (S marks) For the toolbar, press ALT-F10 (PC) O ALTFN+F10 (Mac). BIUS Paragraph 14 EA2 I. *** Aria 11 WWW AAN Chek Sare and Submit ose and numit Clio Save All Arto alla DO ING BAM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!