Oracle
1Z0-047 · Question #62
1Z0-047 Question #62: Real Exam Question with Answer & Explanation
The correct answer is A. No SQL statement would be rolled back.. See the full explanation below for the reasoning.
Question
Given below are the SQL statements executed in a user session: CREATE TABLE product (pcode NUMBER(2), pnameVARCHAR2(10)); INSERT INTO product VALUES(1, `pen'); INSERT INTO product VALUES (2,'penci'); SAVEPOINT a; UPDATE product SET pcode = 10 WHERE pcode = 1; SAVEPOINT b; DELETE FROM product WHERE pcode = 2; COMMIT; DELETE FROM product WHERE pcode=10; ROLLBACK TO SAVEPOINT a; Which statement describes the consequences?
Options
- ANo SQL statement would be rolled back.
- BBoth the DELETE statements would be rolled back.
- COnly the second DELETE statement would be rolled back.
- DBoth the DELETE statements and the UPDATE statement would be rolled back.
Community Discussion
No community discussion yet for this question.