Oracle
1Z0-082 · Question #148
You currently have an active transaction in your session and have been granted select access to vstransaction. In which three situations will re-executing this query still return a row but with a…
The correct answer is B. after successfully executing a create table as select statement followed by a select for update C. after successfully executing a commit or rollback followed by a DML statement F. after successfully executing a truncate statement followed by a DML statement. See the full explanation below for the reasoning.
Manage Data Concurrency
Question
You currently have an active transaction in your session and have been granted select access to vstransaction. In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?
Exhibit
Options
- Aafter successfully executing a commit or rollback followed by a select statement
- Bafter successfully executing a create table as select statement followed by a select for update
- Cafter successfully executing a commit or rollback followed by a DML statement
- Dafter successfully executing a create table statement followed by a create index statement
- Eafter successfully executing a DML statement following a failed DML statement
- Fafter successfully executing a truncate statement followed by a DML statement
How the community answered
(33 responses)- A9% (3)
- B70% (23)
- D6% (2)
- E15% (5)
Topics
#transactions#XID#DDL implicit commit#commit and rollback
Community Discussion
No community discussion yet for this question.