Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 128

Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

    Correct Answer: A, D, F

    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.

Discussion
ivanadjOptions: ADF

https://www.examtopics.com/discussions/oracle/view/8225-exam-1z0-071-topic-1-question-243-discussion/

piontkOptions: ADF

ADF is right

Oracle2020Options: ADF

the real ones are ADF, verified the result obtained is pcode pname 10 pen 3 fountain pen

auwiaOptions: ADF

Provided answer are wrong! The base! :-) part VI

nautil2Options: ADF

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;

RaNik69Options: ADF

a d f are correct