Examine these statements executed in a single Oracle session:
Which three statements are true? (Choose three.)
Examine these statements executed in a single Oracle session:
Which three statements are true? (Choose three.)
The final state of the table after all the operations should be examined step-by-step. Initially, three rows are inserted with pcode 1 (pen), 2 (pencil), and 3 (fountain pen). After that, a savepoint 'a' is created. The pcode for pen is updated to 10 and then committed, making this change permanent. The row with pcode 2 (pencil) is deleted, then savepoint 'b' is created. The pcode for fountain pen is updated to 30, and savepoint 'c' is created. The row with pcode 10 (pen) is deleted, but then the rollback to savepoint 'b' is executed. This rollback undoes changes made after savepoint 'b', restoring deleted pcode 10 (pen) and removing the update that set pcode to 30. Finally, a commit is issued. As a result, 'pen' remains with pcode 10, 'fountain pen' retains pcode 3, and 'pencil' does not exist in the table.
https://www.examtopics.com/discussions/oracle/view/8225-exam-1z0-071-topic-1-question-243-discussion/
ADF is right
the real ones are ADF, verified the result obtained is pcode pname 10 pen 3 fountain pen
Provided answer are wrong! The base! :-) part VI
Correct answer are: A,D,F. Before SAVEPOINT b; command was issued, content of the table is: SQL> SELECT * FROM product; PCODE PNAME ------ -------------------- 10 pen 3 fountain pen The command "ROLLBACK TO SAVEPOINT b; " returns the table to the state created by the SAVEPOINT b;
a d f are correct