Consider the following set of SQL statements:CREATE TABLE MAILING_LIST (FIRST_NAME VARCHAR2(20), LAST_NAME VARCHAR2(30));INSERT INTO MAILING_LIST VALUES ('Smith', 'Mary');What will be the result of the INSERT statement?A. It will fail because there is no column list in the insert statementB. it will fail because there is no primary key in the tableC. it will execute and create a new row in the tableD. It will fail because the last name and first name values are reversed

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