CONSIDER THE FOLLOWING DATE IN A TABLE CALLED PARTS:(the values of the columns are listed in order below)PNO: 1, 2, 3PART_TITLE: processor V1.0 , encasement X770 , board cpu xer A7 STATUS: VALID, PENDING, PENDINGWhich of the following SQL statement will remove the word VALID from row 1, resulting in one row with a status of NULL and two rows with a status of PENDING?A. DELETE FROM PARTS WHERE STATUS = 'VALID';B. DELETE PARTS WHERE PNO = 1;C. DELETE FROM PARTS SET STATUS = NULL WHERE PNO = 1;D. NONE OF THE ABOVE

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