Review the following SQL statements:CREATE TABLE INSTRUCTORS (INSTRUCTOR_ID NUMBER, EXEMPT VARCHAR2(5), VACATION NUMBER, PAY_RATE NUMBER); INSERT INTO INSTRUCTORS VALUES (1, 'YES', NULL, 25);INSERT INTO INSTRUCTORS VALUES (2, NULL, NULL, NULL);UPDATE INSTRUCTORS SET EXEMPT = 'YES' SET VACATION = 15WHERE PAY_RATE < 50;What can be said of the statements listed here?A. ONE ROW WILL BE UPDATEDB. TWO ROWS WILL BE UPDATEDC. AT LEAST ONE OF THE STATEMENTS WILL NOT EXECUTED. NONE OF THE ABOVE

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