Final Practice Query Exam 3 Verified Solutions

Review the following transcript of a SQL*Plus session: INSERT INTO INVENTORY (UPC_CODE, PRODUCT) VALUES (503949353, 'HAZELNUT COFFEE'); INSERT INTO INVENTORY (UPC_CODE, PRODUCT) VALUES (593923506, 'SKIM MILK'); INSERT INTO INVENTORY (UPC_CODE, PRODUCT) VALUES (402392340, 'CANDY BAR); SAVEPOINT INV1; UPDATE INVENTORY SET UPC_CODE = 50393950 WHERE UPC_CODE = 402392340; UPDATE INVENTORY SET UPC_CODE = 4104930504 WHERE UPC_CODE = 402392340; COMMIT; UPDATE INVENTORY SET PRODUCT = (SELECT PRODUCT FROM INVENTORY WHERE UPC_CODE = 50393950) WHERE UPC_CODE = 593923506; ROLLBACK; Which of the following UPC codes will not have records in the INVENTORY table as a result of this series of operations? {Ans: 4104930504 The only record that will not be present from the choices given is 4104930504, because UPC code #402392340 does not exist at the time this statement is issued. It was already changed to 50393950, and thus the 4104930504 update fails when you issue it. As an aside, this question is really tricky because in order to get the answer right you have to read the question for a long time, and that wastes time when you're taking the OCP exams.}You have a script you plan to run using SQL*Plus that contains several SQL statements that manage milk inventory in