Oracle
1Z0-047 · Question #236
1Z0-047 Question #236: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #236. The question stem and answer options stay visible for context.
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,'pencil); 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.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.