Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 117

Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

    Correct Answer: A, B, D

    Initially, three rows are inserted: (1, 'pen'), (2, 'pencil'), and (3, 'fountain pen'). The first COMMIT confirms these entries. Next, there's an update that changes 'pen' to have code 10, making option A accurate. The deletion of 'pencil' is confirmed with a COMMIT, making option D accurate as there is no row containing 'pencil'. The subsequent operations, including updates and deletions, get rolled back to SAVEPOINT b, after 'pencil' is deleted but before 'fountain pen' gets updated. Thus, the final state shows the original code 3 for 'fountain pen' has been restored, making option B true. The result leaves no row for 'pen', so option F is incorrect.

Discussion
lucemqyOptions: ADE

ADE is the correct answer