Consider the following set of SQL statements:CREATE TABLE INSTRUCTORS (INSTRUCTOR_ID NUMBER, NAME VARCHAR2(20), CONSTRAINT ID_PK PRIMARY KEY (INSTRUCTOR_ID), CONSTRAINT NAME_UN UNIQUE (NAME));INSERT INTO INSTRUCTORS (INSTRUCTOR_ID, NAME) VALUES (1, 'Howard Jackson');INSERT INTO INSTRUCTORS (INSTRUCTOR_ID, NAME) VALUES (2, 'Trish Mars');The table will create successfully. What will be the result of two INSERT statement?A. Neither will execute.B. The first will execute, but the second will fail.C. The first will fail, but the second will executeD. both will execute successfully

Then try StudyFetch, the AI-powered platform that can answer your questions and teach you more about it!