Valid 1z0-071 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-071 Exam! ExamDiscuss.com now offer the newest 1z0-071 exam dumps, the ExamDiscuss.com 1z0-071 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-071 dumps with Test Engine here:
Examine these statements executed in a single Oracle session: CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20)); INSERT INTO product VALUES(1,'pen'); INSERT INTO product VALUES (2,'pencil'); INSERT INTO product VALUES(3,'fountain pen'); SAVEPOINT a; UPDATE product SET pcode=10 WHERE pcode =1; COMMIT; DELETE FROM product WHERE pcode =2; SAVEPOINT b; UPDATE product SET pcode=30 WHERE pcode =3; SAVEPOINT c; DELETE FROM product WHERE pcode =10; ROLLBACK TO SAVEPOINT b; COMMIT; Which three statements are true
Correct Answer: A,C,F
* After creation and initial inserts, the pcode for 'pen' is updated to 10, and then committed. * The 'pencil' row is deleted and not yet committed. * A savepoint b is set after the deletion of the 'pencil' row. * The 'fountain pen' pcode is updated to 30, followed by setting savepoint c. * The 'pen' row (now with pcode 10) is deleted. * A rollback to savepoint b reverts the deletion of 'pen' and the update to 'fountain pen', but not the deletion of 'pencil', which was committed earlier due to the scope of the savepoint. * Therefore, after the final commit: * A: The code for 'pen' is 10, since the update was committed and the subsequent delete was rolled back. * C: There is no row containing 'pencil' because its deletion was committed. * F: There is a row containing 'pen' because the deletion was rolled back to savepoint b which was set after the deletion of 'pencil'.