아래 스크립트를 위에서부터 차례로 수행했을 때, 마지막 SELECT 문이 반환하는 값은?
CREATE TABLE STOCK_BATCH (PROD_ID NUMBER, QUANTITY NUMBER);
INSERT INTO STOCK_BATCH VALUES (201, 70);
INSERT INTO STOCK_BATCH VALUES (201, 25);
INSERT INTO STOCK_BATCH VALUES (202, 95);
SAVEPOINT SP_START;
DELETE FROM STOCK_BATCH WHERE QUANTITY < 40;
SAVEPOINT SP_KEEP;
UPDATE STOCK_BATCH SET QUANTITY = 50 WHERE PROD_ID = 201;
ROLLBACK TO SAVEPOINT SP_KEEP;
INSERT INTO STOCK_BATCH VALUES (201, 15);
COMMIT;
SELECT SUM(QUANTITY) FROM STOCK_BATCH WHERE PROD_ID = 201;- 165
- 270
- 3110
- 485
꿈라CBT