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.)
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.
ADE is the correct answer